Hi... My input field is string which contains of text and date in different formats. To unify and compare the data against other file, i need my Field1 rows with different date formats to be consistent. Can you please direct me how to achieve this.
Field1 | Output |
Principal FSM | Principal FSM |
2020-01-10 | 01 Oct 2020 |
15/10/2020 | 15 Oct 2020 |