topic Re: How to extract a word in a string using tjava component? in Talend Studio

How to extract a word in a string using tjava component?

rp2018 — Fri, 15 Nov 2024 23:25:14 GMT

How to extract a word before records in a string?

String1: Test md records.

String2: 123 primary total records to count.

String3: Test records in file 123records.txt.

Extract as follow:

String1: md

String2: total

String3: test

Re: How to extract a word in a string using tjava component?

Anonymous — Tue, 14 Dec 2021 01:00:40 GMT

Assuming these string value comes from a data source, try this expression on tJavaRow:

output_row.columnName=((input_row.columnName.substring(0, input_row.columnName.indexOf("records"))).trim()).substring(((input_row.columnName.substring(0, input_row.columnName.indexOf("records"))).trim()).lastIndexOf(" "));

Let me know if you it works?

Regards

Shong

Re: How to extract a word in a string using tjava component?

Mahamoutou — Tue, 14 Dec 2021 13:37:18 GMT

You could also use regex expression with java replaceAll function like below :

YourInputString.replaceAll( "^(.*?)([A-Za-z]+)(\\s*)(records)(.*?)$", "$2" )

Re: How to extract a word in a string using tjava component?

rp2018 — Tue, 14 Dec 2021 17:54:29 GMT

Thanks this solution worked and only thing I needed to do is to add a replaceall to trim the spaces coming before the output word.