Regex in tmap

[Anonymous]

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

[uzix · Accepted solution]

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    |
'-------------------------------------------------------+---------'

[Anonymous]

Hi..

It's working for me!!..

Thanks,