Numbers formating....

JAYESH · 2008-01-02

Hi Experts...

I created Number Series for Purchase Order.
The No on the Purchase order shows me like 0000000000000001

I want to format this No. and want to show like 1.

Is there any property by setting this its converts..

Thanks in Advance..

And Wishing you a Very Happy New Year..

Thankx...

Savatage · 2008-01-02

Remember it's called Number Series but they are really type CODE not integer.

"I want to show Like"........ Show Where? in a report on the form?

How about converting it to text & removing all the leading zero's.
-for a report

I guess your prepared to make a lot of PO's

0000000000000001 to 9999999999999999
15 zeros brings you into the Quadrillion zone

JAYESH · 2008-01-02

Ok..but my question is

It is possible to conver ?
from 00000000001 to 1 ??

JAYESH · 2008-01-02

Thanx

Alex_Chow · 2008-01-02

JAYESH wrote:

Ok..but my question is

It is possible to convert ?
from 00000000001 to 1 ??

Take a look at the EVALUATE function. It's what you're looking for.

Savatage · 2008-01-02

EVALUATE(VarInteger,"Purchase Header"."No.");

Trivia note: Even if you enter a new po every second it will take you 31,645,570 years to use up all your po numbers.

Give or take

jreynolds · 2008-01-03

If you want to maintain the data as a CODE or TEXT look into the DELCHR function.

Belias · 2008-01-03

jreynolds wrote:

If you want to maintain the data as a CODE or TEXT look into the DELCHR function.

newstr := delchr('010101010101','=','0');
....not really good....

you must delete only useless zeroes...you have to read the code char by char (from left to right obviously) deleting zeroes until you find a character <> '0'...
at this point if you want to mantain the same fieldtype is easier to evaluate and reformat the code....

kine · 2008-01-03

Use

newstr := delchr('010101010101','<','0');

and it will be better... ;-)

Belias · 2008-01-03

yessss...

Numbers formating....

Comments

Categories