Number formatting

[lbalestieri]

Hello there!

Im trying to set a default formatting in my script using the next template:

XXX-NNNNNNNNNN

Where X is a char and N is a number.

Im working with custom receipts and i need that the receipt "1234" looks like "AAA-0000001234".

Who can i do this?

Thank you very much.

[adang · Accepted solution]

You could try this statement in the load script:

Load

'XXX-'&Num(<Numeric field here>, '0000000000')    as  Receipt