REGEX - how to Tokenize numbers "starting with" certain numbers

ELPC

Hi all, 

I have a Text column where PO numbers are entered into with some description of the project.  This text field can have multiple PO numbers and project descriptions.  I am trying to extract out just the various PO numbers and then taking only the last one entered.  My PO numbers can start with 4400XXXX, 4500XXXX, 4600XXXX, 4700XXXX, 4800XXXX or 4900XXXX.  I was able to use RegEx to tokenize each number sequence in one tool but that means I have to use 6 tools to get the 6 sequences. 

I used this expression for the first sequence:  ([4][4][0][0]\d+)  

Is there a way to write the expression so I do not have to use 6 separate tools or is there a way to do it in a formula tool?  Thank you.  

ehughes

Hi @ELPC 

I would use the following expression:

4[4|5|6|7|8|9]00\d{4}

It picks up the 4 for the first digit, then the second digit has to be 4 or 5 or 6 or 7 or 8 or 9, that's followed by two zeros and then any 4 digits after that.

Hope that makes sense and hope it works for you