AnsweredAssumed Answered

Extracting numbers from alphanumeric strings...

Question asked by ToddFerguson on Nov 6, 2011
Latest reply on Nov 27, 2011 by 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

Outcomes