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
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- 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.