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!
Solved! Go to Solution.
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?
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.
Thank you guys!!