5 Replies Latest reply: May 16, 2013 6:54 AM by Peter Schulz RSS

    Cutting off leading zeros

    Peter Schulz

      Hi,

       

      I have a problem with some fields, having leading zeros.

       

      For example a field like OrderNo..

       

      In source 1 the OrderNo. looks like: 00001234567, 00012345678

       

      In source 2 the OrderNo. looks like: 1234567, 12345678

       

      Qlikview don't seem to have a problem with that, but is there a solution to cut off the leading zeroes or to define a lenght e.g. of 14 and fill with zeros?

       

      Or is it unnecessary to care about this?

       

      Thanks for any advice.

       

       

      - PS -