Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.

Alteryx Designer Discussions

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

Split Column with a Specifc word

Tanai_Goncalves
8 - Asteroid

Hello all,

 

Is there a way to split columns with a specific word found in data?

 

I wish to split the column after found the word "CEP"

 

Tanai_0-1583859225309.png

 

Kind Regards,

 

Tanai

 

5 REPLIES 5
Garrett
11 - Bolide

Looks like a job for the "Parse" output method in the RegEx tool:

 

RegEx.PNG

 

I used the Regular Expression: (.*)(CEP)(.*)

fmvizcaino
16 - Nebula
16 - Nebula

Hi @Tanai_Goncalves ,

 

Attached is an example showing how to do it with the parse method from REGEX tool.

fmvizcaino_0-1583859825956.png

 

LEt me know if this works for you.

Best,

Fernando Vizcaino

 

DiegoParker
10 - Fireball

Hi @Tanai_Goncalves 

 

Let me offer you two non-regex approaches.

 

DiegoParker_0-1583860591656.png

 

1) Use a formula + Split to columns. Replace CEP by "~" then do split to columns using "~"

DiegoParker_1-1583860619064.png

 

DiegoParker_2-1583860633659.png

 

2) Use LEFT and RIGHT functions.

 

DiegoParker_3-1583860676310.png

 

Please find the workbook attached.

 

Hope this helps If does, can I ask you to mark it as a solution? this will help other users to find it and will allow us to close the thread. Many thanks!


Best,
Diego

 

 

 

 

Tanai_Goncalves
8 - Asteroid

Excellent. Very easy.

 

Thank you all!

sgwong
7 - Meteor

Need advice word contains symbol <p>  </p>

Labels