5 Replies Latest reply on Nov 27, 2011 6:44 PM by ToddFerguson

    Extracting numbers from alphanumeric strings...

    ToddFerguson

      Title

      Extracting numbers from alphanumeric strings...

      Post

      I receive a report that is imported via tab delimited each morning.

      This includes customers and customer numbers.  However, those two pieces of data aren't seperated on the tab delimited report.

      ex..

      The ABC Company (456789)

       

      I want to pull out the 456789 in a calculation field is fine.  Or, easier way to do this.. 

      Thanks in advance!

       

      Todd