Fill an input field with zeros in VC.

[Former Member]

Hi gurus, i´m trying to format an input field by filling the left spaces with zeros..ex i have a value 3820 as a supplier and i need to format these value as 0000003820, because the ES that i´m running can´t understand thes value. I guess that i have to use a function , but i dont know which one.

Thanks in advance.

Regards.

Diego.

[former_member341000 · Accepted solution]

Hi Diego,

You can use Text Functions -> ZPAD for that purpose, for example, if your input field is in TXT1 in a data store, writing:

=ZPAD(store@TXT1,10)

will pad the text with zeros until it reaches 10 chatacters.

Best regards,

Tal.