更改文本文件分隔符

原创

于 2022-07-27 09:50:59 发布 · 835 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#文本 #数据整理

博主在尝试导入一个以制表符分隔且包含双引号作为文本限定符的文本文件，目标是将分隔符转换为逗号。尝试了derived column transformation和script component方法未果。解决方案是使用SPL脚本，在外部处理文件，将source.txt的分隔符改为逗号并保存到target.txt。

【问题】

I am trying to import a text file in which tab delimited and text qualifier is double quotes.

I want following text

"655295" "Keisuke" "" "Ueda" "1-2-2, Central Park East F201" "Utase, Mihama-Ku"

to convert to

"655295","Keisuke","","Ueda","1-2-2, Central Park East F201","Utase, Mihama-Ku"

I tried derived column transformation, but it did not help. I tried script component, but that didn't work either. Can someone please help me out here.

Thank you in advance!!

题主自己写的待改进代码

public override void Input0_ProcessInputRow(Input0Buffer Row)
    {
        /*
         * Add your code here
         */
        String inputString = Row.line.ToString()