Extracting date From Reference
I have a Column with reference information with date values and the amount; I need to extract only the Date and the Amount, A single reference Pattern Like below:
SIInv:HI-24-SIN-SOH-00948 Date: 12 Mar 2024 Due Date: 04 Jul 2024 Amt: 50.00
The same reference text is added multiple times in a single row. I need to extract only the date values and the amount in an individual column.