How to move columns containing numbers into new column?

John_CMO

I have a column I need to parse job numbers from.

I have several job numbers that can vary in length and contain both numbers and letters, but always start with numbers.

555SSS0123

444AAA3210

409SSS4444

I'd like to be able to add in a formula or RegEx tool to recognize these numbers move them to a new column.

Thanks

Regex

Accepted answers

davidskaife

If it always is on a row by itself, and only contains that code then try ^(\d+\w*)

All comments

davidskaife

Hi @John_CMO

You can use the Formula tool to create a new column, and use the following code to strip out letters and move the numbers only:

Regex_replace([Field1],'[[:alpha:]]','')

John_CMO

Sorry, no I want to keep those numbers intact. There is other data in that column (customer names, payment types, ect.) So I want to pull those job numbers out and move to a separate column

alexnajm

@davidskaife is still right then - put this formula into a new column instead of overwriting an existing one. Or maybe I am misunderstanding

John_CMO

To clarify -

I have several rows in a column with this format, I just want to pull 555SSS0123 out into it's own column

Job Number

Customer PAGE1234 / P AGE LLC Type: Paypal Phone: 123 123-1234

555SSS0123

davidskaife

If it always is on a row by itself, and only contains that code then try ^(\d+\w*)

John_CMO

That worked! Thank-you.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703