split token using regular expression

[peac3]

Hi,

I need to tokenise from a sentence to find action that populated using the real date.

Initially in the input table, the column action is populated using template with date called (dd/mm/yyyy).
As time goes by, the client may or may not follow the sequence which makes a bit complicated.


I need to split the sentence from action column into tokens with delimiter dd/mm/yyyy or real date.
Then the ones with real date, i need to split into date column and summary as per output table.

input table:
Client          Action
ABC             dd/mm/yyyy notice of letter; 01/03/2019 pay the principle. dd/mm/yyyy pay the interest 12/06/2019 pay off the debt; dd/mm/yyyy settle the agreement

output table:
Client          Date          Summary
ABC             01/03/2019    pay the principle.
ABC             12/06/2019    pay off the debt;

Please can you guys shed some light for this query?
Thanks,