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
Solved! Go to Solution.
@sergiogarciagt - can you check if the formula below works for you?
(.*):(\d+)(.*):(\d+).*:(.\d+-\d+)\s(.*)
Regards
Arundhuti
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.
Thank you,
This works better!
SG