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

[rp2018]

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

[Anonymous · Accepted solution]

Hi

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

[Mahamoutou]

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

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

  

[rp2018]

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.

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(" ")).replaceAll(" ", "");