CODEWITHSUNDEEP
talend
StatguyUser
StatguyUser

Reputation: 2665

tReplace not removing comma in Talend workflow

I have a workflow which i am using to remove comma sign , from the data. However its is not working.

enter image description here

Edit: I am adding new screenshots

enter image description here

tMap properties

enter image description here

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

Upvotes: 0

Views: 333

Answers (1)

Viki888
Viki888

Reputation: 2774

Try disabling checkbox "Whole word". If then not working as expected, follow below approach.

Instead of using treplace component, use the code like below in tMap component

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

The above will give you the expected result

Hope this would help you out.

Upvotes: 1

Related Questions