Using text to columns while keeping the delimiter

[BillyL14]

Hi 

Is there any way of separating the value in once cell, like 'value!' into 2 different cells, like 'value' and '!'?

Everytime I try the delimiter (!) is gone.  There are no delimiters in quotes in my data.

Thank you

[atcodedog05 · Accepted solution]

Hi @BillyL14 ,

You can use Regex tool parse mode to split them use below 

(.*)(!)

Output:

Tool config:

Hope this helps 🙂

[jdunkerley79 · Accepted solution]

As with @atcodedog05  suggestion, I would use the Regex Tool but I would use it in Tokenize mode with an expression like:

([^!]+|!)

This allows you to do the same as Text To Columns and either break to columns or rows

Sample attached

[atcodedog05]

Happy to help 🙂 @BillyL14 

Cheers and happy analyzing 😀

[BillyL14]

Hi @atcodedog05 

Thanks for that.

I have several values with different delimiters in this column of data, for example value!, value+, value#, I need to separate them all and keep the delimiter, I have tried putting them all in together and individually, I get an error when I put in the plus sign individually and when I put them all in the expression together, do you know how to do this?

[atcodedog05 · Accepted solution]

Hi @BillyL14 

Try this expression. In the same workflow.

(\w*)(\W)

Output:

Hope this helps 🙂

[atcodedog05]

Guess that worked 🙂

Happy to help 🙂

Cheers and happy analyzing 😀

[BillyL14]

thanks