DSXchange

Hi,

I have a requirement of converting a comma delimited flat file to a fixed width flat file.

The data in the comma delimited flat file looks something like this.

1,CSB01B,7.4,SEA01T,8.4,S1A01R,9.4
2,MUP01C,10.4,FSC01Z,11.4,CDE01F,12.4


I want the data to be in fixed width columns in the target flat file, something like below.

1 CSB01B 7.4 SEA01T 8.4 S1A01R 9.4
2 MUP01C 10.4 FSC01Z 11.4 CDE01F 12.4

Could any one please guide me on this..


Thanks in Advance.

If I understand the problem, have you tried to use the function Ereplace(String,',',' ') ? The data 7.4 must be converted to 'blank'||7.4 or 'blank'||'blank'||7.4

No. This has nothing to do with the transformer derivation.
I have a flat file which is comma delimited. The target must be of fixed width column thats all.

Read the file as comma delimited.

Write the file as fixed width format. The display width will be the width of each column in the written file.

Put a Transformer stage between the two Sequential File stages so that you can have links with different format properties.

Exactly. Simply note the type in each Sequential File stage. And, as Ray notes, understand that the Display size controls the fixed-width column size.