AnsweredAssumed Answered

trim function help

Question asked by ryandunne_1 on Oct 21, 2013
Latest reply on Oct 22, 2013 by philmodjunk

Title

trim function help

Post

     hi all im having a little trouble with the trim function and cant work out how to build it i basicly need to trim the design id out of this long string so i need to trim it to 111616 but it isnt always a certain position from the left or right or in the middle so none of the trim functions fit what i need to trim can anyone help me with the exact function this needs to be?

      

     (banner name: hajj mubarak mum and dad, design id: 111616, width: 1828, height: 610, product: Standard PVC Banner, SRV_VER: V4, order id: 38042;)

      

      (banner name: B&Q JOBS, design id: 111662, width: 3657, height: 1067, product: Standard PVC Banner, SRV_VER: V4, order id: 38058;)

      

     cheers

     ryan

Outcomes