Text to column using the right-most delimiter

matiasb

I need to split a text into a fixed number of columns but want to keep the extra delimiters at the beginning.

For example, using the - delimiter if I got: 123-123-SOMETHING 

I want to get two columns. Column A: 123-123 and column B: SOMETHING

Based on another answer I was thinking in a 3-step solution

Step 1 - Formula to reverse the string

Step 2 - Split to columns with delimiter, 2 columns and leaving extra columns in last column

Step 3 - Reverse back the two column string.

But I was trying to go for a one step solution probably using REGEX or other formulas. 

Basically I'm trying to replicate the following function from PowerBI into a single step in Alteryx:

Does anyone have any insight to resolve using an alternate solution?

atcodedog05

Hi @matiasb 

The regex to be used in a Regex tool parse mode would be something like this

(.*)\-([^\-]+)

(.*) : first all character before - .\- is used to escape - function

([^\-]+) : all character instead of - . this way it splits from the right most.

Workflow:

Hope this helps 🙂

something.yxmd