Reg Ex Help on data extraction

[DodgerFH]

New to RegEx,  and looked through a couple of previous posts on this issue, and the results don't seem to be helping me.    

I have a column "Additional_Information_c"   where the data is populate like so.   Advisor CRD#: 1234567 -- RIA CRD#: 3456789  Need to pull out the 7 digits after Advisor CRD#:   

Tried  .*(#:\d+).*    and  :(\d{7})    both of them are returning empty results.    I am using Output method Parse.   

Thanks in advance for any help

[apathetichell · Accepted solution]

Switch to token:

.*\#\:\s*(\d{7})

I can't tell if there is a space in between the : and the number so I included the \s*

[DodgerFH]

Thank you!  I did not understand the full breakdown of how to break it out.  Gives me a better understanding of how to work the formula.