当前位置: 动力学知识库 > 问答 > 编程问答 >

c# - SSIS remove carriage returns

问题描述:

I've a flat file which has 48 columns. The columns are tab delimited and the rows CR-LF (return).

Now I've the problem that there is a column which sometimes contains carriage returns and there is no possibility to change the file before the import process.

At the moment I wrote a C# script task which looks in every row, counts the tabs and when there is a return and the counted tabs are not divisible by 48 it deletes the return. This way works but it's to slow because my files are very big and with that way I've to read every character in the file.

Does someone knows a better way to get rid of these carriage returns?

Cheers!

分享给朋友:
您可能感兴趣的文章:
随机阅读: