Split Column with a Specifc word

[Tanai_Goncalves]

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"

Kind Regards,

Tanai

[Garrett · Accepted solution]

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

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

[fmvizcaino · Accepted solution]

Hi @Tanai_Goncalves ,

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

LEt me know if this works for you.

Best,

Fernando Vizcaino

[DiegoParker · Accepted solution]

Hi @Tanai_Goncalves 

Let me offer you two non-regex approaches.

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

2) Use LEFT and RIGHT functions.

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]

Excellent. Very easy.

Thank you all!

[sgwong]

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