Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Newbie regex

Hamder83
11 - Bolide

Hi 

How do I phrase this:

UBDK 2022 DAO Denmark Parcel.yxdb

I want it split in 3:

UBDK
2022
DAO Denmark Parcel


Thanks in advance, 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @Hamder83 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644233179098.png

 

Hope this helps : )

 

binuacs
21 - Polaris

@Hamder83 Another RegEx fomula to split the records

(.+?)\s(.+?)\s(.+)\.+

binuacs_0-1644233035908.png

 

Hamder83
11 - Bolide

Hi @atcodedog05  & @bi 

Thank you both of you. Great solutions. I accespted @atcodedog05's solution simply because he was faster :-) 

have a nice day

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Hamder83 

Cheers and have a nice day!

Labels
Top Solution Authors