how can we handle this type date scenarios

[Anonymous]

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:-

Dates

1957

1959

1969

1971

[Anonymous]

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:-

Dates

1957

1959

1969

1971

[TRF]

Same answer as for your 1rst topic https://community.talend.com/t5/Design-and-Development/how-can-apply-filter-on-dates/m-p/137929#M857...

It seems the question is not clear. Maybe you need to use a regex. Try to detail your need if you want a detailed answer.