6 Replies Latest reply: Jun 26, 2014 9:15 AM by Kasia Cwik RSS

    How to trim a field value at a load from database?

    Kasia Cwik

      Hi,

       

      I am loading a field from a database, the record values needs to be trimmed on both beginning and end

       

      example:

       

      00000063359701549001538000000000

       

      I need the first six 0's and last 8 0's to be removed, min you the 9th 0 from the end is needed, I don't want that to be removed.

       

      Any ideas?