Split Column with a Specifc word

Question

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 Answer

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

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

fmvizcaino · Accepted Answer

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 Answer

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