Splitting date and text into 2 columns

[hongen909]

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:

Description

11/07ADPGROSS-TO-NET

to this:

Date	Description
11/07	ADPGROSS-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

[gawa · Accepted solution]

hi @hongen909 

I recommend to use Regex tool like attached workflow.

[hongen909]

It worked, thank you very much!