topic Filter data on first character in Talend in Talend Studio

Filter data on first character in Talend

Anonymous — Tue, 22 Dec 2015 20:37:40 GMT

Hi,
I have an input flat file data coming as below and I need to filter data based on first character such as "R" and "S" in talend.
Can anyone please suggest me.
Sample data:
R01
R02
R03
S01
S02
S03
S04
S05
Thanks,
Yugandhar

Re: Filter data on first character in Talend

Anonymous — Wed, 23 Dec 2015 06:41:06 GMT

Hi,
Do you need to filter the row with non-integer value for your column or just filter the row which starts with "S" or "R"?
Best regards
Sabrina

Re: Filter data on first character in Talend

Anonymous — Wed, 23 Dec 2015 14:03:40 GMT

Hi,
I want to filter the row which starts with "S" or "R.

Thanks,
Yugandhar

Re: Filter data on first character in Talend

Anonymous — Thu, 24 Dec 2015 02:29:46 GMT

Hi,
You can achieve your goal in tMap component by using this filter:
row1.newColumn1.startsWith("S")||row1.newColumn1.startsWith("R")
Let us know if it is OK with you.
Best regards
Sabrina

Re: Filter data on first character in Talend

Anonymous — Thu, 24 Dec 2015 14:52:20 GMT

Thank you Sabrina!

Re: Filter data on first character in Talend

Anonymous — Fri, 25 Dec 2015 07:10:53 GMT

Hi,
Thanks for your feedback. Feel free to mark this topic as resolved.
Best regards
Sabrina