[resolved] to filter rows having specifyword

Highlighted
One Star

[resolved] to filter rows having specifyword

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


Accepted Solutions
Moderator

Re: [resolved] to filter rows having specifyword

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




--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post


All Replies
Moderator

Re: [resolved] to filter rows having specifyword

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




--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog