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
issue with extral line feeds
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for the suggestions so far.
I think I'm getting closer, but in effect, my ultimate goal is to join two rows that have been artificially broken by the presence of the wayward LF.
The file is delimited, so I use the Count function to identify the row with the extra LF. For those rows, my syntax is Convert(FromSrc.FullRow, char(10), " ").
My thought was that if I removed the LF from the input rows in question, the output target would then contain the broken records joined back together. Does it sound like I'm on the right track? I'm getting the feeling that I may be approaching this incorrectly.
I think I'm getting closer, but in effect, my ultimate goal is to join two rows that have been artificially broken by the presence of the wayward LF.
The file is delimited, so I use the Count function to identify the row with the extra LF. For those rows, my syntax is Convert(FromSrc.FullRow, char(10), " ").
My thought was that if I removed the LF from the input rows in question, the output target would then contain the broken records joined back together. Does it sound like I'm on the right track? I'm getting the feeling that I may be approaching this incorrectly.