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



      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