EXTRACTING THE DIGITS IN A COLUMN

[dunkindonut7777]

Hi How can I separate these first 9 digits in a column? I dont know exactly the formula using the regex tool.

Field	Expected Output
105730408  CBCLH-/PUB() CA-IntB-JPY-000910021960	105730408
105730407  PRC-/PUB() CA-IntB-USD-000910021971	105730407

Can you help me with this one please?

[ShankerV · Accepted solution]

Hi @dunkindonut7777 

Please use the below formula in Regex tool

(\d+)

Output method = Parse

Many thanks

Shanker V

[caltang · Accepted solution]

There are two ways:

If you just want the first 9, then you can use either

LEFT([Field],9)

OR REGEX

(\d{9}).*