3 Replies Latest reply: May 31, 2016 3:21 AM by Jose Luis Dengra RSS

    Any way to add trailing spaces i.e. pad data out

    N G

      Hi,

       

      I have a field from sql data i.e. MyField but I need it to be padded to 40 characters with trailing spaces in a chart i.e. MyFieldSSSSSSSSSSSSSSSSS

      (where S is a space)

       

      I know there are sql functions..

       

      i.e. to pad to a certain length (20, in this example): left('MyText' & space(20), 20)


      ..but QV script does not like this.


      Does anyone know  either a script or an expression function that could achieve this please ?


      Thanks in advance

      Bob