AnsweredAssumed Answered

Select serial number from text

Question asked by Imre... on Sep 6, 2013
Latest reply on Sep 6, 2013 by philmodjunk

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

Outcomes