Combining multiple columns (Post Reg-EX) into respective columns?

[shong]

Hello,

In my first column, I have varied ways of how an "ID" was entered (with spaces, without space, etc.). I used a RegEX to parse it out but it came out to be 4 different columns. I would like to merge The RegEXOut3 and RegEXOut4  into RegEXOut1 and RegEXOut2, respectively.

I tried using the transpose tool, but it was not returning the intended results.

Thanks for any insights!

[MarqueeCrew · Accepted solution]

Try:
(\w\w\)s*-\s*(\d+)

Use it in a regex tool to parse your input.

Cheers,

Mark

[shong · Accepted solution]

Thanks Mark!

I slightly modified the formula you provided: (\w\w)*\s*-*\s*(\d+) and it worked!