Help with RegEx

[Jmacnevin]

Hello,

I'm trying to use the RegEx tool to parse the following string of digits contained in a field:

-9 followed by 18 random digits.  For example: -9123456789101112131

I tried Text to Columns, using "-" as the delimiter; however, there are instances where two or more "-" exist in the field.  There are also instances where a second unique string of -9xxxxxxxxxxxxxxxxxx follows the first string.  I only want the first string of -9xxxxxxxxxxxxxxxxxx. 

Using multiple Text to Columns, filters ext seems to give me the result I want, but I would like to find a simpler (and easier to verify) solution.

Thanks in advance,

Jeff

[KGT · Accepted solution]

Have you got sample data for the different cases you could come across?

Try this one: (\-[9]\d{18})

[Jmacnevin]

Hi,

Yes.  These are the kinds of records I'm looking at.

thanks 

Jeff

[Jmacnevin]

I believe that worked.  Thanks!!