topic Find key word in text using tRecordMatching in Talend Studio

Find key word in text using tRecordMatching

Anonymous — Thu, 28 Jan 2016 03:48:15 GMT

Hello,
I have two spreadsheets where I which to find matching records in a column from each spreadsheet.
So in spreadsheet1, col 1, I have the following:

Paint
Electrical
Plumbing
paint
Lights
Light
In Spreadsheet 2, col 1, I have the following:

This is a job that requires point
New electrical is needed
Plumber to replace tap
No lights working

So my match would need to show
Plumber = Plumber to replace tap
Light = No lights working
Etc etc

I have been looking at the following with some success but not perfect.

Re: Find key word in text using tRecordMatching

Anonymous — Thu, 28 Jan 2016 05:25:16 GMT

Could you please show us the output , And settings of tjoin ?

Re: Find key word in text using tRecordMatching

Anonymous — Thu, 28 Jan 2016 07:08:20 GMT

use variable in tmap
and put the this syntax "row1.Col1.toLowerCase().contains(row2.Col2.toLowerCase()) "
Then you would be able to get the existence of input col string in lookup col string.
Best !!

Re: Find key word in text using tRecordMatching

Anonymous — Thu, 28 Jan 2016 10:28:50 GMT

Thanks Roy,
I tried your suggestion (thanks) and this is how it looks.

[img=177x100]https://www.talendforge.org/forum/img/members/26681/mini_blob_20160128-1134.png[/img]