How to convert delimited file to fixed width file.

prashanthgovindaraj · Post by **prashanthgovindaraj** » Thu Feb 07, 2008 4:25 am

How to convert delimited file(comma delimited) to fixed width file?. Kindly advise.

dhanashreepanse · Post by **dhanashreepanse** » Thu Feb 07, 2008 5:11 am

Read the input in a sequential file. Put a transformer after that. Put another sequential file stage and set the property "Record Length" to Fixed.

Ragunathan Gunasekaran · Thu Feb 07, 2008 7:10 am

Use a copy or modify stage instead of the transformer. Using transformer for all purpose should be restrained

ArndW · Post by **ArndW** » Thu Feb 07, 2008 7:18 am

Actually, in this case just do a Sequential Stage -> Sequential Stage. If your delimited file has VarChar fields you will have to use a modify or transform stage to convert the datatypes to fixed width ones.

dspxlearn · Post by **dspxlearn** » Thu Feb 07, 2008 8:01 am

How about converting all the fields of target sequential stage data types to Char.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 07, 2008 2:12 pm

Remember that Format and Column properties are properties of the Link, not of the stage. In a job with only two Sequential File stages there is only one link, so any change will be manifested on both ends of the link. You will need an intermediate stage, probably a Modify stage. You might also like to be alert to the effect of APT_STRING_PADCHAR environment variable which, by default, will pad your Char fields with 0x00 characters.