4 Replies Latest reply on Sep 6, 2013 7:10 AM by philmodjunk

    Select serial number from text

    Imre...

      Title

      Select serial number from text

      Post

           Hello,

           I used to select an 9-digit serial number from a static point from this text:

           DBC_GGZ-[9-DIGITSERIALNUMBER]-GZ311_V21_RED

           This week the serialnumber are made of 10 digits.

           My reports nu contain serialnumbers with either 9- or 10 digits. 

            

           How can I select the serialnumber from this text?

            

           ==

            

           Example: 

            

           DBC_GGZ-933699-GZ311_V21_RED 

           should result in: 933699

            

            

           DBC_GGZ-1003914-GZ311_V21_RED

           should result in: 1003914

      Schermafbeelding_2013-09-06_om_11.59.44.png