[resolved] to filter rows having specifyword

lmit — Fri, 17 Jul 2015 06:15:28 GMT

Hi all,
i have a requirement like i need to filter data based on few words in string instead of full word
Below is how my data looks
s.no|name
1|a
2|b
3|123R
4|1R23
i need data which is having the letter R in the last,which means i need 3rd record but 4th should not come. I tried tfilterrow but i couldn't achieve it.I will always get the letter in the last only(Like 123R) and i need to declare this filter condition in context variable
Do anyone suggest any other method or process

Thanks in advance
lmit

Re: [resolved] to filter rows having specifyword

Anonymous — Fri, 17 Jul 2015 08:47:36 GMT

Hi,

I will always get the letter in the last only(Like 123R) and i need to declare this filter condition in context variable

Have you tried to use method Java String.endsWith() in advanced mode of tFilterRow?
Best regards
Sabrina

topic [resolved] to filter rows having specifyword in Talend Studio

[resolved] to filter rows having specifyword

Re: [resolved] to filter rows having specifyword