Removing Leading zeros

Posted by: William Takamori

Removing Leading zeros - 11/16/10 04:46 PM

Hey Guys!
How to remove trailing zeros from a database, so they do not appear in the preview?
Thanks!
Posted by: Raphael Lalonde Lefebvre

Re: Removing Leading zeros - 11/18/10 09:58 AM

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
Posted by: William Takamori

Re: Removing Leading zeros - 11/18/10 10:10 AM

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
Posted by: Raphael Lalonde Lefebvre

Re: Removing Leading zeros - 11/18/10 10:17 AM

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
Posted by: William Takamori

Re: Removing Leading zeros - 11/18/10 10:33 AM

Raphaël
When i switch to "number" the data disappear.
The data box is blank.

Thanks
Posted by: William Takamori

Re: Removing Leading zeros - 11/18/10 10:44 AM

In warning, following message appears:
Variable "total" "0000000000000999,86" is not a valid number
Posted by: Raphael Lalonde Lefebvre

Re: Removing Leading zeros - 11/18/10 11:45 AM

Did you use that field in an expression? If so, what is the expression that uses it?
Posted by: William Takamori

Re: Removing Leading zeros - 11/18/10 11:53 AM

No. no have expression in this field.
Posted by: Anonymous

Re: Removing Leading zeros - 11/18/10 12:00 PM

Hi william,

Maybe replacing the comma by a period could help.

Regards,

Olivier