I use a report containing purchase order numbers consisting of an alphabetic prefix followed by five numbers. There will always be the five numbers but the number of characters in the prefix varies. I only want to trap the numbers but I can't figure out how to trap correctly. Here is an example:
Receiving Doc.# 537837 on Jan.07/08 PO#WKSC56017
Receiving Doc.# 603737 on Dec.04/08 PO#D-MKSC51452
I want to return a field call PO # that just has the numbers. I'm usually pretty good at this and feel that I'm missing something obvious. All help appreciated.