I'm kinda new to PP Design, but I have created a metadata field from a flat file which has a currency field that has leading "0". It is a 8 digit field, last two being the decimal(cents) of the field. How do I format the MetaData I'm pulling in to suppress leading "0"'s?

Thanks,
A.j.

AJ,

Maybe you can try converting the amount to a currency, and then back to a string.

For example, in the value of your metadata field, you could use:

curtostr(strtocur(@(1,1,10)))

The @(1,1,10) is a sample data selection, use your own data selection.

Here, we first convert the amount to an actual currency variable. By doing this, it should take care of the leading zeroes. Of course, we need to convert it back to a string, so we use curtostr to put it back to string. However, the zeroes will have been removed.

Hope that helps!

Regards,
Raphaël Lalonde Lefebvre

Thank you soooo much. Worked like a charm..

a.j.