topic Re: [resolved] Removing everything after a specified character in Talend Studio

[resolved] Removing everything after a specified character

Anonymous — Thu, 01 Oct 2015 05:38:07 GMT

I am new to Talend and fairly new to anything JAVA/scripting related so would really appreciate your help.
I have a range of telephone numbers which I would like to clean up using the tMap component.
I have successfully managed to remove spaces etc, however in this field, my company has stored a lot of telephone extensions so typically the number would look like this:
092081146x713
I would like to remove everything after the 'x' and then store the value after the 'x' in a variable and then populate the another column with the data after the 'x' so that the telephone extension is not lost when we migrate our systems next year.
Please help
Caz

Re: [resolved] Removing everything after a specified character

Anonymous — Thu, 01 Oct 2015 09:20:00 GMT

use tMap and str.substring(str.lastIndexOf("x") + 1) ?

Re: [resolved] Removing everything after a specified character

avinashbasetty — Thu, 01 Oct 2015 15:32:45 GMT

Hi Caz,

You could try this,It works

For the phone number- row1.phone.split("x") [0]
For the phone extension- row1.phone.split("x") [1]

Thanks,
Regards,
Avinash

Re: [resolved] Removing everything after a specified character

Anonymous — Mon, 05 Oct 2015 02:32:00 GMT

Thanks guys...will test this in about an hour
will let you know how it goes...

Re: [resolved] Removing everything after a specified character

Anonymous — Mon, 05 Oct 2015 03:28:06 GMT

Thanks j1122, this worked like a charm