First "0" is missing when displaying a number starting with "0", with GTL

Question

I need to display numeric value in transnational email. I'm parsing json with GTL. Some times the payload can have a value like 012345, but in the email the display is 12345. I tried to format with formatNumber() in ampscript but the "0" is still truncated.

Json payload saved in the DE:

[{"FulfillmentDetail":{"TrackingNumber": "012345"} }]

Parsing wwith GTL :

{{.datasource FulfillmentDetail type=nested maxRows = 1}} 
           {{.data}} { "target" : "OrderLine.FulfillmentDetail" } {{/data}} 
            {{TrackingNumber}}
{{/datasource}} 

Result in Email

12345

Expected :

012345

The alternative solution is to add the value between single quotes. But this would implies tricky dev in the applications that launch the payload. So i'm searching to resolve this during the parse, in GTL/ampScript

Answer 1

If you use the formatnumber function you can keep the leading zero:

{{=formatnumber(TrackingNumber, "d6")}}

here is the doc for using Ampscript within GTL

Answer 2

Another solution is using format function that can retrieve both numeric with leading zero and string char

{{=format(TrackingNumber, '0#####')}}

Thanks @EazyE AMPScript/GTL function to check if variable is string or a numeric

Answer 3

I've found that if you concatenate the value with an empty string, it will return a string that will include the leading zeros.

For example: TreatAsContent("{{=concat(var_name, '')}}")