DSXchange

One of my source systems it appears has decided to put your random CF/LF's into a couple fields. What are some methods you employ to inspect and remove them where they don't belong?

Thanks for any suggestions.

Unless you have permission to remove them, you should not. These are part of the source data.

Assuming, then, that you do have permission to remove them, my preference in a server job is to create a stage variable (called svCRLF for example) initialized to Char(13):Char(10) and to use a Convert() function such as