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 works for me.
Did you change the tFileInputFullRow schema?

[vboppudi]

Used data provided by you. 

Logic in tReplace is

Regards,

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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.

---

[Anonymous]

forgot to add :-

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

row1.latest_file_col_list(" ","_") 

still not working