topic Re: Put comma separator to a string in Application Development and Automation Discussions

Put comma separator to a string

Former Member — Tue, 15 May 2007 09:29:18 GMT

Hello everyone!

When I execute this:


DATA: myAmount TYPE p DECIMAL 2, myString TYPE string.

myAmount = 1234567.89.
myString = myAmount.

WRITE: myAmount, ' ; ', myString.

The output is 1,234,567.89 ; 1234567.89

How can I put back the comma separators to the string? Is there a built-in function that can do this or do I need to write my own?

Thanks a lot guys!

Message was edited by:

Ricardo Caliolio

Re: Put comma separator to a string

Former Member — Tue, 15 May 2007 09:31:42 GMT

Hi,

You can set the currency defaults in Syetem => User Profilr => Own Data.

This currency format will be used for display.

regards

Re: Put comma separator to a string

Former Member — Tue, 15 May 2007 09:33:21 GMT

Instead of this :

myString = myAmount.

Use this :

WRITE myAmount To myString .

Hope this helps you.

Re: Put comma separator to a string

Former Member — Tue, 15 May 2007 09:46:16 GMT

hi,

goto System => User Profile => Set Data.

then output data for string variables displayed as u get for ur programs.

if helpful reward some points.

with regards,

suresh.

Re: Put comma separator to a string

Former Member — Tue, 15 May 2007 09:55:57 GMT

how did u get the output with ur code..

it gives dump...

Re: Put comma separator to a string

Former Member — Tue, 15 May 2007 09:59:16 GMT

hi,

u have to put comma by ur own.

Regards,

NRT

Re: Put comma separator to a string

Former Member — Tue, 15 May 2007 10:07:38 GMT

Hi,

The write statement has an formatting extension

USING EDIT MASK (mask)

This should solve your problem 7 if so Plz be generous with points...

Regards,

Gaurav

Re: Put comma separator to a string

former_member196280 — Tue, 15 May 2007 10:08:41 GMT

Hi Ricardo,

Here is the solution for your question.

DATA: myAmount TYPE p DECIMALS 2, myString(15).

myAmount = '1234567.89'.

WRITE myAmount TO myString . "Using this statement will automatically give,

WRITE: myamount ,myString.

MOVE myAmount TO myString . "SImilar to myString = myAmount.

WRITE: myamount ,myString.

So, now the output for this code is

MyAmount Mystring

1,234,567.89 1,234,567.89 -->Using WRITE ...TO

1,234,567.89 1234567.89 --> Using MOVE... TO or Equals

Reward points for all useful answers.

Regards,

SaiRam

Re: Put comma separator to a string

Former Member — Tue, 15 May 2007 10:20:19 GMT

Hi ,

we can't assign a value 1,234,567.85 to a packed number directly.

How did you assign it and got the output.

It is giving errors know?

Regards,

Balakrishna.N

Re: Put comma separator to a string

Former Member — Wed, 16 May 2007 11:13:50 GMT

> Hi Ricardo,

> Here is the solution for your question.

> DATA: myAmount TYPE p DECIMALS 2, myString(15).

> myAmount = '1234567.89'.

> WRITE myAmount TO myString . "Using this

> statement will automatically give,

> WRITE: myamount ,myString.

> MOVE myAmount TO myString . "SImilar to myString

> = myAmount.

> WRITE: myamount ,myString.

> So, now the output for this code is

> MyAmount Mystring

> 1,234,567.89 1,234,567.89 -->Using WRITE ...TO

> 67.89 1234567.89 --> Using MOVE... TO or

> Equals

> Reward points for all useful answers.

> Regards,

> SaiRam

Hello. I think this is a good idea but it conflicts with my another problem. I posted this with the title "How to remove spaces when printing amounts" in this same forums.

Thanks!

Re: Put comma separator to a string

Former Member — Wed, 16 May 2007 11:16:20 GMT

> Hi,

> You can set the currency defaults in Syetem => User

> Profilr => Own Data.

> This currency format will be used for display.

> regards

Hello. But this only applies to numerical data types and not strings... ^_

Thanks!

Re: Put comma separator to a string

Former Member — Wed, 16 May 2007 11:17:56 GMT

> Instead of this :

> myString = myAmount.

> Use this :

> WRITE myAmount To myString .

> Hope this helps you.

This is not working when I tried it but this one do:

MOVE myAmount TO myString.

However, it has the same result as:

myString = myAmount.

Thanks!

Re: Put comma separator to a string

Former Member — Wed, 16 May 2007 11:19:01 GMT

> hi

> how did u get the output with ur code..

> it gives dump...

I think it is just a dummy code.. But the logics is there so just try to modify it a little.. ^_

Thanks!

Re: Put comma separator to a string

Former Member — Wed, 16 May 2007 11:19:50 GMT

> hi,

> u have to put comma by ur own.

> Regards,

> NRT

I think I am already starting to believe this... ^_

Thanks!

Re: Put comma separator to a string

Former Member — Wed, 16 May 2007 11:23:06 GMT

> Hi,

> The write statement has an formatting extension

> USING EDIT MASK (mask)

> This should solve your problem 7 if so Plz be

> generous with points...

> Regards,

> Gaurav

I'm sorry but I am not yet used to using this.. Can you please elaborate? Thanks a lot! ^_

Re: Put comma separator to a string

Former Member — Mon, 08 Oct 2007 03:32:29 GMT

Comma should be put manually to strings.