issue with extral line feeds
Posted: Mon Nov 28, 2011 12:00 pm
I've seen some replies to problems similar to this, but haven't yet been quite able to make anything work.
We have a sequential file coming from a vendor in which a particular column occasionally contains a LF character (X'0A'), even though the end of the row has not actually occurred. Of course that causes my DS job to consider the data as two rows.
I've seen suggestions of using the EReplace and Convert functions to replace it with a space, but so far nothing I've tried will get rid of it. Due to the nature of the data I am always able to recognize the location of the extra LF, but I haven't come up with a way that actually seems to replace it.
Thanks for any suggestions.
Tom
We have a sequential file coming from a vendor in which a particular column occasionally contains a LF character (X'0A'), even though the end of the row has not actually occurred. Of course that causes my DS job to consider the data as two rows.
I've seen suggestions of using the EReplace and Convert functions to replace it with a space, but so far nothing I've tried will get rid of it. Due to the nature of the data I am always able to recognize the location of the extra LF, but I haven't come up with a way that actually seems to replace it.
Thanks for any suggestions.
Tom