Parse values inside parenthesis with tMap

zalibra — Tue, 11 Feb 2020 19:59:08 GMT

I have a combination of values in my "input_data" field which I need to put in two separate fields. Below are the possible values in "input_data":

1. US Dollar (USD)

2. JEP

3. Zimbabwean Dollar (2009) (ZWL)

I would want my output to be:

output_1 output_2

1. US Dollar USD

2. JEP

3. Zimbabwean Dollar (2009) ZWL

For output_1, I used:

row1.input_data.substring(0,row1.input_data.indexOf("("))

and for output_2, I used:

row1.input_data.substring(row1.input_data.indexOf("(")+1,row1.input_data.indexOf(")"))

but it gave an error for JEP since there was no parenthesis and for the other two, the output was:

output_1 output_2

1. US Dollar USD

3. Zimbabwean Dollar 2009

Whenever there are two parentheses, I always want to take the second value for output_2. Does anyone know what the commands for output_1 and output_2 should be?

Re: Parse values inside parenthesis with tMap

Anonymous — Fri, 14 Feb 2020 07:17:05 GMT

Hi
For output1:
row1.c1.contains("(")?row1.c1.substring(0,row1.c1.lastIndexOf("(")):row1.c1

for output2:
row1.c1.contains("(")?row1.c1.substring(row1.c1.lastIndexOf("(")+1,row1.c1.length()-1):""

Please try and let me know if it works.

Regards
Shong

Re: Parse values inside parenthesis with tMap

zalibra — Fri, 14 Feb 2020 20:05:09 GMT

Worked! Thanks.

topic Parse values inside parenthesis with tMap in Talend Studio

Parse values inside parenthesis with tMap

Re: Parse values inside parenthesis with tMap

Re: Parse values inside parenthesis with tMap