cancel
Showing results for 
Search instead for 
Did you mean: 

file content convertion

Former Member
0 Kudos

hi,

I am doing File to file scenario.but the situation is like this

the input in the text file will be abc~~xyz and the output should be taken as

abc~ as 1st field and xyz as 2nd field and second ~ as Field seperator.

how can i do this.can i use fieldFixedLengths and fieldSeperator both..

then which one will have higher priority?

Accepted Solutions (1)

Accepted Solutions (1)

former_member189441
Active Participant
0 Kudos

hi ,

you can do this by using only "fieldFixedLengths".if u give both operators then

it will take fieldifixedLengths only into consideration.it ignores the

second ~.so if u give the fieldFixedLengths then what ever the fieldSeperator

it will ignores that and will give ur 2 fields as u like

Answers (1)

Answers (1)

GabrielSagaya
Active Contributor
0 Kudos

You have to use fieldFixedLength alone.

since ~ occurs twice you cannot split the word.

Record.FieldFixedLength=4,3

Record.fieldNames=f1,f2