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



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






      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?