in reply to Clean data - where field contains a CRLF
My generic response to this would be "How do you tell when a line end character is not end of record? Is it number of fields? Some special information contained in your data? Once you know the answer to that, then the best way to solve your problem should be easy to figure out." That said, GrandFather's response is educational as always...