Regex for multiple numbers within a cell

[sergiogarciagt]

Hi,

I am trying to extract from the description below, the number 411011, however it is returning me the 2021. I am using the following regex "(\d+[A-Z]*)(?!.*\d)", any ideas on how to fix it?

Thanks,

REVENUES - OPERATIONS:41000 Tuition and Fees:411011 · Registration:2020-2021 Registration Fees

[Tyro_abc]

@sergiogarciagt  - can you check if the formula below works for you?

(.*):(\d+)(.*):(\d+).*:(.\d+-\d+)\s(.*)

Regards

Arundhuti

[Tyro_abc]

Forgot to attach workflow

[sergiogarciagt]

Hi,

Thank you for your help. I tried the formula and it parses the data, however it created 6 different regex outputs. Is there any way of having it to select just the numbers I want. Another formula I have been using is "(\d+[A-Z]*)(?!.*[^ -/'$#\|\d+]\d)" but this one returns 2020 so it still does not get the account number 411011. The tricky part with this description is that it contains accounts plus sub accounts in the same cell.

[Tyro_abc · Accepted solution]

Like this?

[sergiogarciagt]

Thank you,

This works better!

SG