Skip to Content
0
Former Member
Dec 09, 2009 at 10:23 AM

File layout problem

29 Views

We have the target .txt file,when opened the same in excel we see some problems.

eg F1,F2,F3,F4& F5 are the five fields,if all the fileds are present ,there is no layout problem,suppose there is no F3,F4 fields say in the input sent then the out put seen is F1,F3,F5 THE OUT PUT EXPECTED is F1,BLANK,F3,BLANK,F5.

This not the only case any field may anot come from the input from five

for this five field i used the elow mapping if F1 =! null then F1 else constant (if f1 is 8 chars ,i am leaving 8 spaces) with this the output seen is.

F1,F2,Blank,F5.

Content conversion parameters.

ignoreRecordsetName true.

Records.fieldNames F1,F2,F3,F4& F5

Records.fieldSeparator'0x09'

Rows.endSeparator'nl'

Thanks,

Srinivasa