6 Replies Latest reply: Aug 27, 2018 3:04 PM by Sunny Talwar RSS

    Ltrim in load statement

    Mallika Mhapankar

      Hi guys,

      I have a field named "Product" that has  numbers which start with zeroes that I want to get rid of.

      For example, some of the entries in this field are:

       

      0000002344

      00000213456

      00000000023

       

      I want to get rid of the zeroes and keep only the numbers

      2344

      213456

      23

       

      and I want to name this new column as "PRODUCT" and I want to do this under a load statement. not in the SQL that extracts this column. I tried a Ltrim but it didnt work

      Can someone help me with the code?