【问题】

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();
 
        int count = Row.line.Split('"').Length - 1;
        int counter = 1;
 
        while (counter < count)
        {
            if (counter % 2 == 0)
            {
                int StartIndex = GetNthIndex(inputString.ToString(), Convert.ToChar("\""), counter);
                int EndIndex = GetNthIndex(inputString.ToString(), Convert.ToChar("\""), counter + 1);
 
                inputString = inputString.ToString().Substring(0, StartIndex + 1) + "," +
                inputString.ToString().Substring(EndIndex);
            }
            else
            {
            }
            counter = counter + 1;
        }
        Row.OutputLine = inputString;
    }
    int GetNthIndex(string s, char t, int n)
    {
        int count = 0;
        for (int i = 0; i < s.Length; i++)
        {
            if (s[i] == t)
            {
                count++;
                if (count == n)
                {
                    return i;
                }
            }
        }
        return -1;
    }

【回答】

更改csv文件的分隔符，这种工作可以在外部做，比如用SPL来实现，脚本如下：

A1：读取文本source.txt

A2：将 A1 中的分隔符改成逗号后导出到target.txt文本中

写好的脚本如何在应用程序中调用，可以参考Java 如何调用 SPL 脚本