I have a workflow which i am using to remove comma sign , from the data. However its is not working. I tried un-checking "Whole word" field too, but to no avail.
Solved! Go to Solution.
Here the string to change:
"a piece, of text, with undesired, commas,"
and the result:
[statistics] connected a piece of text with undesired commas [statistics] disconnected
I wonder if it is because i am using tFileInputFullRow component? I tried not only on this field, but also on other fields too, yet it is not working.
i think tReplace working as expected.
i used tReplace to replace ',' with '-', please find the output below.
Starting job job_replace at 08:10 19/04/2017.
[statistics] connecting to socket on port 3842
Job job_replace ended at 08:10 19/04/2017. [exit code=0]
If you use tFileInputFullRow, you have a single field called "line" by default, don't you?
Can you share your job (tFileInputFullRow schema and tMap)?
How do i share the workflow? I mean any tutorial on how to export and secondly, i do not see any filed in this discussion forum to attach anything
I have added the images below. Also some sample data
id Shenzhen City, Guangdong, China Rest of Hunan, China China Wuxi City, Jiangsu, China Jinshan District, Shanghai, China JingÕan District, Shanghai, China Yangpu District, Shanghai, China