topic Re: Numeric conversion in Application Development and Automation Discussions

Numeric conversion

Former Member — Wed, 31 May 2006 15:43:52 GMT

Hi,

One of the variables has values stored as 2,000.000

I need to modify this to 2000

ANy ideas?

regards

Message was edited by: Nishant Gupta

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:46:14 GMT

hi,

take data type interger.

dirrectly assigne to it.

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:47:17 GMT

move that value to an integer type variable.

REgards,

Ravi

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:47:25 GMT

hii

change the decimal settings in your system

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:47:33 GMT

Hi,

var2 type I.

var1 = 2,000.000

var2 = var1.

rgds,

latheesh

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:49:31 GMT

i tried moving it to integer type variable..

i am getting the following message in DUMP.

"Unable to interpret " 2,000.00 " as a number."

Regards

Nishant

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:51:06 GMT

Hi,

check this..

REPORT  ZTEST_NUMBER                            .

data: number1(10) type p decimals 3,
      number(10) type n.


      number1 = '2000.000'.
     move number1 to number.
     write number1.
     write number.

Regards

vijay

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:51:09 GMT

Try this code:

REPORT zh_test1 NO STANDARD PAGE HEADING.

data: v_val type p decimals 2 value '2000.00',

v_int type i,

v_char(10).

write:/ v_val.

v_int = v_val.

write:/ v_int.

v_char = v_int.

write:/ v_char.

REgards,

Ravi

Re: Numeric conversion

RichHeilman — Wed, 31 May 2006 15:52:35 GMT

You must first get rid of the comma, then move to an integer field.



report zrich_0001.


data: c(15) type c value '2,000.00'.
data: i type i.

translate c using ', '.
condense c no-gaps.

i = c.
write:/ i.

Regards,

Rich Heilman

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:53:15 GMT

guys,

number is " 2,000.00 "

and NOT "2000.00"

...there's a comma as well

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:54:49 GMT

Hi Nishant,

Message was edited by: Manoj Gupta

Re: Numeric conversion

Former Member — Wed, 31 May 2006 15:59:30 GMT

Thanks a lot Rich.

Re: Numeric conversion

Former Member — Wed, 31 May 2006 16:02:17 GMT

Hi Nishant,

PLease note that Rich's code will work for only in countries where , is the thousands separator and '.' for decimal separator.

In some countries (JAPAN) the , is for decimals.

So take care before you implement this code.

Regards,

Ravi