topic Re: Formatting numbers in Application Development and Automation Discussions

Formatting numbers

Former Member — Thu, 04 Dec 2008 13:45:46 GMT

Hi all.

Does anybodey know a FM that can convert numbers threw requested formats?

Meaning 1,544,631 turn into 1.544.631 and the like.

Thanks you all,

Rebeka

Re: Formatting numbers

Former Member — Thu, 04 Dec 2008 13:47:50 GMT

use concatenate statements to arrange the numbers

Re: Formatting numbers

Former Member — Thu, 04 Dec 2008 13:48:06 GMT

Use REPLACE statement.

You can split it at ',' and then concatenate them separated by dot.

Thanks

Re: Formatting numbers

Former Member — Thu, 04 Dec 2008 13:52:16 GMT

hi Rebeka ,

Take a variable of character type with required length example

Data:

gv_amount(20) type c.

Symply take the currency field and use WRITE TO statement to the variable. The currency will be written as per user format.

Example.

data:

gv_wrbtr type bseg-wrbtr.

assume some value in gv_wrbtr. Now simple write the below stt. to get the maintained user format.

write gv_wrbtr to gv_amount currency currency_field.

Venkat.

Re: Formatting numbers

Former Member — Thu, 04 Dec 2008 13:52:46 GMT

As such there is no FM.

You need to write code by using REPLACE command in your string in desired formats.

Re: Formatting numbers

Former Member — Thu, 04 Dec 2008 13:56:14 GMT

Hi all.

I don't want to use any REPLACE statement and so..

What if ther's a value appears like 1.001.2 (Thousand and one dot 2) and I want to replace it to 1,001.2 ?? I want to use a std. FM if there is such.

Re: Formatting numbers

Former Member — Thu, 04 Dec 2008 14:00:45 GMT

use FM conversion_exit_alpa_input

Re: Formatting numbers

rainer_hbenthal — Thu, 04 Dec 2008 14:02:17 GMT

There is no function module for that. You have to write your own code, a good thing is to use a turing machine such as a [Busy beaver|http://en.wikipedia.org/wiki/Busy_beaver]

Re: Formatting numbers

Former Member — Thu, 25 Dec 2008 10:43:14 GMT

dfsdf