topic Re: tReplace not removing comma in Talend workflow in Talend Studio

tReplace not removing comma in Talend workflow

Anonymous — Wed, 19 Apr 2017 13:50:59 GMT

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.

Re: tReplace not removing comma in Talend workflow

TRF — Wed, 19 Apr 2017 13:56:09 GMT

It should works with tMap and the following regex:

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

Re: tReplace not removing comma in Talend workflow

Anonymous — Wed, 19 Apr 2017 13:59:04 GMT

Not working either. I tried that too.

Re: tReplace not removing comma in Talend workflow

TRF — Wed, 19 Apr 2017 14:04:28 GMT

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.

Re: tReplace not removing comma in Talend workflow

Anonymous — Wed, 19 Apr 2017 14:10:20 GMT

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.

Re: tReplace not removing comma in Talend workflow

vboppudi — Wed, 19 Apr 2017 14:15:31 GMT

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,

Re: tReplace not removing comma in Talend workflow

TRF — Wed, 19 Apr 2017 14:16:04 GMT

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

Re: tReplace not removing comma in Talend workflow

Anonymous — Wed, 19 Apr 2017 15:08:04 GMT

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

Re: tReplace not removing comma in Talend workflow

TRF — Wed, 19 Apr 2017 15:09:56 GMT

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

Re: tReplace not removing comma in Talend workflow

Anonymous — Wed, 19 Apr 2017 15:11:28 GMT

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

Re: tReplace not removing comma in Talend workflow

TRF — Wed, 19 Apr 2017 15:17:12 GMT

It works for me.
Did you change the tFileInputFullRow schema?

Re: tReplace not removing comma in Talend workflow

vboppudi — Wed, 19 Apr 2017 15:22:28 GMT

Used data provided by you.

Logic in tReplace is

Regards,

Re: tReplace not removing comma in Talend workflow

Anonymous — Wed, 19 Apr 2017 15:35:12 GMT

The tReplace should work , have you tried unchecking the whole word?

Re: tReplace not removing comma in Talend workflow

Anonymous — Wed, 19 Apr 2017 15:43:50 GMT

yes it worked. However, if there are 2 columns, it gives issues.

Re: tReplace not removing comma in Talend workflow

Anonymous — Fri, 12 Jul 2019 11:26:25 GMT

Hi,

If I have multiple condition to replace like below :-

A|B should be A,B

A B should be A_B

I gave condition like below :-

row1.latest_file_col_list("|",",") ||

row1.latest_file_col_list(" ","_")

@Enthusiast wrote:

yes it worked. However, if there are 2 columns, it gives issues.

It is giving me syntax error. Please suggest.

@Enthusiast wrote:

yes it worked. However, if there are 2 columns, it gives issues.

Re: tReplace not removing comma in Talend workflow

Anonymous — Fri, 12 Jul 2019 11:30:34 GMT

forgot to add :-

row1.latest_file_col_list("|",",") ||

row1.latest_file_col_list(" ","_")

still not working