Regex to split text

[Stephaniesinclair]

Hi, 

I want to split a text box into two columns:  Deploy Active Directory to Ireland in 2023

COLUMN 1: Deploy Active Directory to

COLUMN 2: Ireland in 2023

How do I configure the Regex tool? Thanks in advance.

[Felipe_Ribeir0]

Hi @Stephaniesinclair 

One way of doing this

(.*\sto\s)(.*)

[ShankerV]

Hi @Stephaniesinclair 

One way of doing this,

Use Regex tool : (.+\sto)\s(.+)

By this way, we can achieve eliminating the trailing whitespace at the end of column1.

Many thanks

Shanker V

[MichelleMitchellLutz]

Fantastic addition! Thanks for sharing. Regex has been challenging for me to understand, this helps.