This content has been marked as final. Show 3 replies
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