Constructing an attribute from a text and number attribute

[ask180]

Guys,
I need to populate an attribute that is plain text 8.

The first four characters come from a plain text 4 attribute already existing in the database. No problem.

The second part (4 characters) comes from a number attribute that is initialised to zero. Each time I need to populate the plain text 8 attribute, I add one to the number field.

For example, the first time the plain text attribute will be populated with ABCD0001, the second time ABCD0002 etc.

The problem is that I can't get the four numbers to store with leading zeros - it currently looks like ABCD1.0 - and I don't know why.

On the number attribute, I defined a custom format ####, hoping that would do it. The format saves okay, but when I inspect the attribute, AwareIM has changed it to a decimal - hence the 1.0.

I also tried various things using AS_STRING, but that approach saves it as ABCD1 - no leading zeros before the 1.

Does anyone know of a trick to get the format with leading zeros working?

[PointsWell]

Pad

https://www.awareim.com/dokuwiki/doku.p ... f/pad_left

[ask180]

Thanks for the advice. Much appreciated.