I am currently working on a process with a lot of string manipulation. I need to get three dates from a string that will be in a consistent order, but the rest of the data positions are inconsistent. I’d like to remove all characters from a string that isn’t a date in the format “dd/MM/yyyy”.
Example string: 20/10/2020 6741002 1042687,William Coulson, ISP, From 20280935 6,364.24 12/10/2020 - To 08/11/2020, ‘Service Level Example string - (Forum Specific) (Placement)’, SPOT,
I have got a Regex for removing the date, but I need it the other way round.
Has anybody done this before for similar instances? Or can help me with the above instance?
Thanks in advance.