topic Re: Formatting floating point numbers into a string in Application Development and Automation Discussions

Formatting floating point numbers into a string

martin_dietiker — Mon, 24 Aug 2009 13:46:35 GMT

Hi,

I am relatively new in ABAP and I am searching for a FM or function to convert a given floating point number into a string using a given format (like using the [DecimalFormatter|http://java.sun.com/javase/6/docs/api/java/text/DecimalFormat.html] class in Java).

eg.

Number: 1234.56

Format: #,##0.00

Result 1,234.45

Number: 1234

Format #,##0.00

Result: 1,234.00

Number 0.34

Format: #,###.##

Result: .34

Number: 0.34

Format: #,##0.00

Result. 0.34

Number: 0.56

Format: 0.0

Result: 0.6

Number: 1234.56

Format: abc#,###

Result: abc1,235

and so on

I have already tried the 'using mask' expression in the write command and also the FM 'C14N_NUMERIC_FORMAT' but without my desired results.

Any idea

regards Martin

Re: Formatting floating point numbers into a string

Former Member — Mon, 24 Aug 2009 14:32:56 GMT

Hi,

You can use WRITE....TO statement to convert. which converts the contents of the source field into a field with type C

WRITE <f1> TO <f2> <Options>

Eg:

DATA: NUMBER TYPE F VALUE '4.3',

TEXT(10),

FLOAT TYPE F,

PACK TYPE P DECIMALS 1.

WRITE NUMBER TO TEXT EXPONENT 2.

WRITE NUMBER TO FLOAT.

WRITE NUMBER TO PACK.

Regards

Shiva

Edited by: Shiva Kumar Tirumalasetty on Aug 24, 2009 8:03 PM

Re: Formatting floating point numbers into a string

martin_dietiker — Mon, 24 Aug 2009 14:54:10 GMT

Thx Shiva,

but this dosn't solve my problem. I 'simply' want to apply a format like described above to the number and thus get the number in the desired format.

eg.

I have a float number 1234.34 which is stored in the float field like 1.23456E+3. I have a format telling me to show only the integer part of this number (like 1234). My idea is to apply a format '###9' to that number and it will give back a string containing '1234'. Likewise with the other format expressed in my original question.

hope this makes my question a bit more understandable.

regards

Martin

Re: Formatting floating point numbers into a string

Sandra_Rossi — Mon, 24 Aug 2009 19:56:25 GMT

I've never seen that. In SAP, we don't bother with formats, we usually have requirements which require only one format. I'm afraid that you have to code it yourself.

Re: Formatting floating point numbers into a string

former_member156446 — Mon, 24 Aug 2009 20:04:41 GMT

Use 'FLTP_CHAR_CONVERSION' in this you can mention the number of decimal place you want to have...

Re: Formatting floating point numbers into a string

retired_member — Wed, 17 Aug 2016 12:39:48 GMT

Nowadays, you format numeric data into strings with embedded expressions in string templates and their formatting options:

Embedded expressions - format options

WRITE TO is the old fashioned way ...