how can apply filter on dates

Anonymous — Thu, 18 Oct 2018 10:01:12 GMT

Hello Everyone,

i have a date scenario, where i can find and split dates

Date Of BIRTH:-
26 Sep 1946 to 07 Dec 1946

CIRCA 01 Jan 1955 to 31 Dec 1956
'1959', '
'1960',
'1952',
'1952',
'1969 to 1971
'1969 to 1971
'1969 to 1971
'1969 to 1971
'1969 to 1971
CIRCA 1949',
CIRCA 1949',
CIRCA 1961'
'1961'
'1961'
'1961',
'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959

And i want to filter "1957 to 1959" and split dates in this format

Output:-

Date Of BIRTH:-

'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959
'1957 to 1959

Re: how can apply filter on dates

TRF — Sun, 21 Oct 2018 07:54:32 GMT

These are dates, just strings. So you can use a simple tFilterRow or tMap to achieve what you want.

topic Re: how can apply filter on dates in Talend Studio

how can apply filter on dates

Re: how can apply filter on dates