CODEWITHSUNDEEP
talend
DrGenius
DrGenius

Reputation: 967

Read correctly a value which includes the file's delimiter

I have a column which suppose to take the value: hello, Ted

But because the delimiter of the file is "," it separates the sentence into two columns.

column1: hello

column2: Ted

How can I output the: hello, Ted?

Thanks in advance.

Upvotes: 0

Views: 158

Answers (2)

Omar AlSaghier
Omar AlSaghier

Reputation: 340

You can read the file with "tFileInputRow" first as line by line, and "look and replace" for each line for the comma with space (", ") and replace it with space only (" ") using a piece of Java code inside "tJavaRow". After that try to extract the fields based on the desired schema using tExtractFields component and move on as usual.

Upvotes: 1

Abhishek
Abhishek

Reputation: 2490

Your source data needs to redefined and have the data in Text enclosure with "". Once that is set you can handle by enabling CSV option in basic setting of tFileInputDelimited.

enter image description here

Upvotes: 1

Related Questions