topic Re: Regex in tmap in Talend Studio

Regex in tmap

Anonymous — Thu, 05 Mar 2020 08:50:24 GMT

Hi.

I have a question. My input data as below and i need to extract the 5 digits to put into column PlaceCode.

Can you help me on how i can get the exact 5 digit for column PlaceCode?

For example:

Input:

Place

89 1st Floor Jalan P. Samad 93400 Kuching P.o. Box 1543

Tingkat 2, Jalan Kulas 84201 Kuching

12-E Tingkat 42, Wisma Jalan Kamaruddin 20400 Kuala

Output:

Place	PlaceCode
89 1st Floor Jalan P. Samad 93400 Kuching P.o. Box 1543	93400
Tingkat 2, Jalan Kulas 84201 Kuching	84201
12-E Tingkat 42, Wisma Jalan Kamaruddin 20400 Kuala	20400

Thanks,

MKAIL

Re: Regex in tmap

uzix — Thu, 05 Mar 2020 12:37:49 GMT

hello,

you could use the regex in a tjavarow to extract that info.

in advanced settings of tjavarow , add:

import java.util.regex.*;

example code :

1 column input - name "inputData":

2 output columns : "output" and "PlaceCode"

//Code generated according to input schema and output schema

Pattern pattern = Pattern.compile("\\b\\d{5}\\b");
Matcher matcher = pattern.matcher(input_row.inputData);
output_row.PlaceCode="";
output_row.output = input_row.inputData;

	while(matcher.find()) {
            //System.out.println("found: " + matcher.group());
            output_row.PlaceCode = matcher.group();
            }

result:

.-------------------------------------------------------.
|                      tLogRow_11                       |
|=-----------------------------------------------------=|
|inputData                                              |
|=-----------------------------------------------------=|
|89 1st Floor Jalan P. Samad 93400 Kuching P.o. Box 1543|
|Tingkat 2, Jalan Kulas 84201 Kuching                   |
|12-E Tingkat 42, Wisma Jalan Kamaruddin 20400 Kuala    |
'-------------------------------------------------------'

.-------------------------------------------------------+---------.
|                           tLogRow_13                            |
|=------------------------------------------------------+--------=|
|output                                                 |PlaceCode|
|=------------------------------------------------------+--------=|
|89 1st Floor Jalan P. Samad 93400 Kuching P.o. Box 1543|93400    |
|Tingkat 2, Jalan Kulas 84201 Kuching                   |84201    |
|12-E Tingkat 42, Wisma Jalan Kamaruddin 20400 Kuala    |20400    |
'-------------------------------------------------------+---------'

Re: Regex in tmap

Anonymous — Fri, 06 Mar 2020 02:30:46 GMT

Hi..

It's working for me!!..

Thanks,