tReplace not removing comma in Talend workflow

[Anonymous]

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.

[TRF]

It should works with tMap and the following regex: 

row1.id.replaceAll(",", "")

[Anonymous]

Not working either. I tried that too.

[TRF]

It does.

Here the string to change:

"a piece, of text, with undesired, commas,"

the tMap:

and the result:

[statistics] connected
a piece of text with undesired commas
[statistics] disconnected

Try again.

[Anonymous]

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.

[vboppudi]

Hi Azimulh,

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
[statistics] connected
.-----------.
|SourceData |
|=---------=|
|COL |
|=---------=|
|ABC,XYZ,123|
|ZXC,VBN,M |
|ASD,FGH,JKL|
'-----------'

.-----------.
|AfterReplace|
|=---------=|
|COL |
|=---------=|
|ABC-XYZ-123|
|ZXC-VBN-M |
|ASD-FGH-JKL|
'-----------'
[statistics] disconnected
Job job_replace ended at 08:10 19/04/2017. [exit code=0]

Regards, 

[TRF]

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)?

[Anonymous]

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

[TRF]

You can attach a captured image (click on the camera when editing a post)

[Anonymous]

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