Separate data in one column in 2 with delimiter "space"+"dash"+"Space.

[bigdaddyvette]

Can Someone assist me in separating Text to Columns with 3 delimiters.... delimiters are (space)(dash)(space). into 2 columns.... for example separating "Garcia-Morales, Fred - E123456" attempting to get result of second column to be just "E123456"?

[fmvizcaino]

Hi @bigdaddyvette ,

Attached is a solution showing how to do it with regex and text to columns also.

Let me know if this makes sense to you.

BEst,

Fernando Vizcaino

[AlexBibin]

This works:

[MarqueeCrew]

You could use a Replace function as:

replace([field]," - ", '|')

 then use a text to columns with the pipe | as the delimiter. 

cheers,

 mark

[bigdaddyvette]

Thank You 🙂

[bigdaddyvette]

Thank You

[bigdaddyvette]

Appreciate It, thks