regex parse and text to column

[556891a]

Hi everyone,

I have a question about how to use text to column and regex to split the following example.

Ex:

George178-11Mo   to George, 178, 11, Mo

BRE22-564Y.         to BRE, 22, 564, Y

Those have different lengths and formats, so I have no idea how to do that.

Thanks!

[markcurry]

See the attached workflow, the following RegEx should split your input...

(\D+)(\d+)\-(\d+)(\D+)

[grossal · Accepted solution]

Hi @556891a,

here is a way to do this:

Output:

Let me know if this works with your other data or if we need to adapt something. Workflow attached.

Best

Alex