Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
17 - Castor
17 - Castor

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
8 - Asteroid

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

Labels