Leading zeros - Objectif Lune Tech Support Self Help

IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

You are not logged in. [Log In] Objectif Lune » Forums » PrintShop Mail 6 » Expressions, Functions and Databases » Leading zeros

Topic Options

#24661 - 09/08/09 03:31 PM Leading zeros
pfriden Junior Member Registered: 09/08/09 Posts: 3 Loc: Norway	I have an expression which is supposed to put Leading zeros to Norwegian zip codes. The zip code should always be 4 digits. This works with PSM version 5 but I can't get it to work with version 6. The expression is: IF(LEN( [Postnr])= 2,"00" &
Top

#24662 - 09/08/09 03:34 PM Re: Leading zeros
Raphael Lalonde Lefebvre OL Expert Registered: 10/14/05 Posts: 4956 Loc: Objectif Lune Montreal	pfriden, Did you try changing your variable's type to Text? Go to the variables list(Window->Variables if you don't see it), select the variable that contains the zip code, and in it's properties(Window->Properties), change it's type to Text. Let us know if that works! Regards, Rapha
Top

#24663 - 09/08/09 04:59 PM Re: Leading zeros
pfriden Junior Member Registered: 09/08/09 Posts: 3 Loc: Norway	Thank you! That made the difference. I've tried to do the formatting in Excel but that didn't work. Regards /Per
Top

#24664 - 09/09/09 07:32 AM Re: Leading zeros
Anonymous Unregistered	You can also use RIGHT("000" & [postnr],4) - also works if there's 1 digit in the database.
Top

#24665 - 09/09/09 02:43 PM Re: Leading zeros
pfriden Junior Member Registered: 09/08/09 Posts: 3 Loc: Norway	Thanks! I had never used the Function "Right" in that way. That is much easier. The database included a one digit zip code so I had already extended my expression. This one I can remeber. /Per
Top

#24666 - 09/15/09 11:55 AM Re: Leading zeros
sellis OL Newbie Registered: 07/11/07 Posts: 21	I find using "COUNTER([Variable],[Variable],0,6,True)" works well. You can adjust the amount of leading zeros without the need to know the length of the field/variable.
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, OL Newsgroup Support, OL Newsgroup Training, Raphael Lalonde Lefebvre