Splitting date and text into 2 columns

Question

Hi,

I have this dataset as attached.

I would like to split the dates and text into 2 different columns.

For example, for record #2,

I want to convert from this:

Description11/07ADPGROSS-TO-NET

to this:

DateDescription11/07ADPGROSS-TO-NET

May I know how to go about doing this?

Note that I have fields that do not contain dates and thus would like to keep them as they are and only split those fields with dates.

Thank you!

Regards,

Hong En

Screenshot 2023-10-01 183145.png

gawa · Accepted Answer

hi @hongen909

I recommend to use Regex tool like attached workflow.