One of the column has many separators.

[Anonymous]

Hi All,

I get data in the below format in txt file

"a","b","c","d","e","f,g,h,i,j,k","l","m","n","o","p","q","r","s"

We want "f,g,h,i,j,k" to be populated as one column to the next component. When we are using "," separator, it is producing many lines. In this "f,g,h,i,j,k", there are number of random commas. How do we get "f,g,h,i,j,k" as one column to the next components?

Your response would appreciated.

[TRF]

If data are coming from a tFileInputDelimited, set the Text enclosure to "

[Anonymous]

Still  have the problems, 

I have written java code and each row data sending as string to  a variable.  

How to get that variable to the next component. Here , I am looking for tIterateToFlow component.  

Please suggest.

[TRF]

You need to give us more details regarding the job design.

What is the the data source? a text delimited file? a database? something else?

[Anonymous]

It is comma separated file, the data comes as I listed in this case. I have done the java code to replace the ',' separators with in the column and then, whole row of the data is going as a string variable. I want to fetch that variable and load it to as csv file in S3 bucket. 

[cterenzi · Accepted solution]

When reading in a comma-delimited file with quote enclosures, I set the text enclosure setting to "\"" so that the Java code translates it to a quotation mark.