tMap STRING how to replace ")" with "-"

[profuse]

In tMap, row1.phone contains the value (800)777-1234

How do to replace "(" with "" and also replace ")" with "-"

So the result should look like 800-777-1234

Thanks

[Anonymous · Accepted solution]

Hi,

Please refer below output.

The function is as below.

row1.data.replace("(","").replace(")","-")

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

StringHandling.CHANGE(row1.phone,"(","").CHANGE(row1.phone,")","-")

[profuse]

Perfect Thank You!