How do I strip out a second CR/LF pair that randomly appears in a flat file
Posted on 2013-05-21
I'm using SSIS to import some flat files. They are fixed length and use a CRLF as a row delimiter. However, there are some cases (like every 5000 lines) where there is a second CRLF pair. This messes up my import and rejects a number of records. I'm trying to figure out a way to remove any occurrences of <CR><LF><CR><LF> to just be <CR><LF> Any suggestions?