Removing 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 » Removing Leading zeros

Topic Options

#33962 - 11/16/10 04:46 PM Removing Leading zeros
William Takamori OL Newbie Registered: 11/16/10 Posts: 7 Loc: Brazil	Hey Guys! How to remove trailing zeros from a database, so they do not appear in the preview? Thanks!
Top

#33976 - 11/18/10 09:58 AM Re: Removing Leading zeros [Re: William Takamori]
Raphael Lalonde Lefebvre OL Expert Registered: 10/14/05 Posts: 4956 Loc: Objectif Lune Montreal	William, Do you mean the leading or trailing zeroes? You said Leading in your title, but here you say trailing... it's two different things. Can you give us a sample of how your data shows up, and what you want it to look like? Regards, Raphaël Lalonde Lefebvre
Top

#33977 - 11/18/10 10:10 AM Re: Removing Leading zeros [Re: Raphael Lalonde Lefebvre]
William Takamori OL Newbie Registered: 11/16/10 Posts: 7 Loc: Brazil	Sorry, Raphael. I want remove leading zeros. Data: 000000010569.98 000000001499.79 0000000002465.1 000000001877.98 000000001499.79 000000001499.79 000000000967.21 000000001846.24 000000001556.23 000000001765.67 000000001765.67 000000001559.13 000000001766.66 000000001559.13 000000001369.67 000000002810.96 000000001085.59 000000001674.99 000000001674.99 000000003027.57 000000001085.59 000000001085.59 000000001674.99 000000001674.99 000000001674.99 000000001201.46 000000001201.46 000000001201.46 000000001201.46 000000002521.58 000000003775.32 2.000,00 4.602,00 000000003292.81 000000003209.99 000000002541.92 ########################################### It should look like this: 10569.98 1499.79 2465.1 1877.98 1499.79 1499.79 967.21 1846.24 1556.23 1765.67 1765.67 1559.13 1766.66 1559.13 1369.67 2810.96 1085.59 1674.99 1674.99 3027.57 1085.59 1085.59 1674.99 1674.99 1674.99 1201.46 1201.46 1201.46 1201.46 2521.58 3775.32 2.000,00 4.602,00 3292.81 3209.99 2541.92 Thanks
Top

#33978 - 11/18/10 10:17 AM Re: Removing Leading zeros [Re: William Takamori]
Raphael Lalonde Lefebvre OL Expert Registered: 10/14/05 Posts: 4956 Loc: Objectif Lune Montreal	William, In your list of variables(go to Window->Variables if you don't see it), highlight the variable that displays the number with the zeroes. Then, go to the properties (Window->Properties if you don't see it), and change the variable's type from Text to Number instead. This should automatically take care of the leading zeroes. Regards, Raphaël Lalonde Lefebvre
Top

#33979 - 11/18/10 10:33 AM Re: Removing Leading zeros [Re: Raphael Lalonde Lefebvre]
William Takamori OL Newbie Registered: 11/16/10 Posts: 7 Loc: Brazil	Raphaël When i switch to "number" the data disappear. The data box is blank. Thanks
Top

#33981 - 11/18/10 10:44 AM Re: Removing Leading zeros [Re: William Takamori]
William Takamori OL Newbie Registered: 11/16/10 Posts: 7 Loc: Brazil	In warning, following message appears: Variable "total" "0000000000000999,86" is not a valid number
Top

#33986 - 11/18/10 11:45 AM Re: Removing Leading zeros [Re: William Takamori]
Raphael Lalonde Lefebvre OL Expert Registered: 10/14/05 Posts: 4956 Loc: Objectif Lune Montreal	Did you use that field in an expression? If so, what is the expression that uses it?
Top

#33987 - 11/18/10 11:53 AM Re: Removing Leading zeros [Re: Raphael Lalonde Lefebvre]
William Takamori OL Newbie Registered: 11/16/10 Posts: 7 Loc: Brazil	No. no have expression in this field.
Top

#33988 - 11/18/10 12:00 PM Re: Removing Leading zeros [Re: William Takamori]
Olivier J Unregistered	Hi william, Maybe replacing the comma by a period could help. Regards, Olivier
Top

Previous Topic

Index

Next Topic

Hop to:

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