How to convert delimited file to fixed width file.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 13
- Joined: Tue Oct 30, 2007 8:33 am
- Location: Chennai
How to convert delimited file to fixed width file.
How to convert delimited file(comma delimited) to fixed width file?. Kindly advise.
-
- Participant
- Posts: 25
- Joined: Fri Jan 11, 2008 12:49 am
- Location: Pune, India
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.