Topic Options
#33962 - 11/16/10 04:46 PM Removing Leading zeros
William Takamori Offline
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 Offline
OL Expert

Registered: 10/14/05
Posts: 4953
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 Offline
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 Offline
OL Expert

Registered: 10/14/05
Posts: 4953
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 Offline
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 Offline
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 Offline
OL Expert

Registered: 10/14/05
Posts: 4953
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 Offline
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