CR/LF Scrubing
Posted: Wed Mar 29, 2006 9:57 am
Hi,
I am trying to create a routine that will scrub carriage returns and line feeds from the end of a field in the transform stage while the job is processing. This happens on our customer data when individuals cut and paste their address and leave a trailing CR/LF. My file layout is fixed and when this issue is incountered, the job aborts. To manually fix, I open the file in ultra edit and place cursor on corresponding line, backspace, hit the space bar twice to reposition the remaining fields of the record.
Is there any other way to rid CR/LF from a record?
Any help would be great.
Thanks, Steve
I am trying to create a routine that will scrub carriage returns and line feeds from the end of a field in the transform stage while the job is processing. This happens on our customer data when individuals cut and paste their address and leave a trailing CR/LF. My file layout is fixed and when this issue is incountered, the job aborts. To manually fix, I open the file in ultra edit and place cursor on corresponding line, backspace, hit the space bar twice to reposition the remaining fields of the record.
Is there any other way to rid CR/LF from a record?
Any help would be great.
Thanks, Steve