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.
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.