1 Reply Latest reply: May 15, 2014 10:04 AM by Data Kruncher RSS

    Field/Floating trap kind of question

    Marc Osborne

      Hello,

       

      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.

       

      Marc