Replace $ in SalesData Column

[abhi90]

I have a Column Where SalesData is coming. Now with Numbers in start of the data $ is coming. as well as some Data is having value like "$-" which I have to replace with "UNK" otherwise as it is. Now I am trying with replaceall in tmap variableport.Both can be handled in One tmap VariablePort?

Sample Data

$10700.50

$-

@rhall, @TRF, @manodwhb, @vboppudi

[vboppudi]

Yes, you can handle both in tMap variable ports.

Regards,

[abhi90]

In One Variable Port I want to do. I am doing like this now:

row1.COLUMN.replaceAll("$","")=="$-"?"UNK":row1.COLUMN.replaceAll("$","").But not working. @vboppudi

[vboppudi]

try below one

Regards,

[abhi90]

Hi @vboppudi,

Can You please write the replaceall part?It's almost impossible to read

[vboppudi · Accepted solution]

row2.Amount.equals("$-")?"UNK":row2.Amount.replaceAll("[^\\d.]", "") 

Regards,

[abhi90]

Yes.It's perfectly working.Thanks a lot @vboppudi