Re^2: Clean data - where field contains a CRLF

I think you understand where I was heading. One thought as I slept on it last night was could you split multi-line records using and capturing the EN since it is the first character of the record. Then remove the extra CRLFs except for the last one. I do not know if this is possible using the split command over multiple lines. Thoughts? Thanks Mike

Comment on Re^2: Clean data - where field contains a CRLF

Replies are listed 'Best First'.
Re^3: Clean data - where field contains a CRLF by rir (Vicar) on Aug 21, 2006 at 13:41 UTC
Yes, you can. `Split` doesn't care about newlines unless they are in its first argument. Be well, rir	[reply] [d/l]