Text to Columns

[sariyaj]

Is there a way to use a certain word as a delimiter and keep that word. 

For example, if I am trying to separate a column using the word "city", can I do that and keep the actual word in the previous column.

Example:

from this:

Oklahoma City OK 12345

to this: 

Oklahoma City

OK

12345

it doesn't really work out if I put in a certain word as a delimiter.

Thank you for your help in advance!

[FinnCharlton]

Hi @sariyaj , 

You can do this with the RegEx tool:

[sariyaj]

I'm sorry, I'm not familiar with the reg ex tool, I understand you used parse as you output method. But did you use marked group in your expression? Which expression helped you get to that solution?

[FinnCharlton · Accepted solution]

I've attached the workbook so you can have a look, the expression I've used is:(.+City)\s(.+?)\s(.+)

The marked groups are in brackets.

Also, there are plenty of RegEx tutorials online to help you understand what this expression is doing.

[binuacs · Accepted solution]

@sariyaj One way of doing this

[sariyaj]

Thank you guys!!