更改文本文件分隔符

润乾软件

于 2022-07-27 09:50:59 发布

阅读量817

点赞数

CC 4.0 BY-SA版权

分类专栏： JAVA计算文章标签：文本数据整理

本文链接：https://blog.youkuaiyun.com/raqsoft/article/details/126008205

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

【问题】

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()