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!

grossal

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

2020-04-20-regex parse and text to column.yxmd