Need a specific lines value from text field

[Dik2]

Hi All,
i have one text column(History) in which there are all history is maintain line by line
like create date ,delete date,modified date
for example:

date	history
01-01-2022	created on 14-10-2012 modified on 24-10-2012 modified on 26-10-2012  deleted on 30-10-2012  modified on 1-11-2012  created on 12-11-2012
02-01-2022	created on 13-08-2016 modified on 24-09-2016 created on 12-11-2016 modified on 24-10-2016

Required Output:

date	history
01-01-2022	modified on 24-10-2012 modified on 26-10-2012  modified on 1-11-2012
02-01-2022	modified on 24-09-2016  modified on 24-10-2016

[Vegar]

Maybe you could try to split your field rows into distinct field values. When you done that you could filter your values as you would on any other field. 

Try to identify how to split the different lines. As it seems like you have linebreak in your field then you might be able to split them on the invisible line break character ( chr(10).

When you identified a char or string then you can load the field into multiple values using subfield, like this:

load date, history as hiatory_orig, subfield (history, chr(10)) as history_new

from Soure;

Now you have field values and you can either limit the output using set analysis in the front end or limit which values you want to load into your data model in the back end script.