topic Re: Replace $ in SalesData Column in Talend Studio

Replace $ in SalesData Column

abhi90 — Tue, 17 Apr 2018 15:47:34 GMT

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

Re: Replace $ in SalesData Column

vboppudi — Tue, 17 Apr 2018 16:00:26 GMT

Yes, you can handle both in tMap variable ports.

Regards,

Re: Replace $ in SalesData Column

abhi90 — Tue, 17 Apr 2018 16:03:29 GMT

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

Re: Replace $ in SalesData Column

vboppudi — Tue, 17 Apr 2018 16:29:43 GMT

try below one

Regards,

Re: Replace $ in SalesData Column

abhi90 — Tue, 17 Apr 2018 17:00:57 GMT

Hi @vboppudi,

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

Re: Replace $ in SalesData Column

vboppudi — Tue, 17 Apr 2018 17:02:57 GMT

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

Regards,

Re: Replace $ in SalesData Column

abhi90 — Tue, 17 Apr 2018 17:08:05 GMT

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