topic handle separator in string variable in Application Development and Automation Discussions

handle separator in string variable

Former Member — Mon, 25 Oct 2010 06:48:34 GMT

hi everyone

Im receiving lines containing quantity fields and amount fields.

Both fields can have dot and comma as separator

and space as thousand separator

249 522,99

149,637.81

145,89,56

Im trying to use a TRANSLATE, but the comma , space and dot are getting interchanged

can anybody help please?

Re: handle separator in string variable

nabheetscn — Mon, 25 Oct 2010 06:51:52 GMT

What is the requirement..? If you want to format "," or "." then go for write to and move to statment.

Nabheet

Re: handle separator in string variable

Former Member — Mon, 25 Oct 2010 06:58:53 GMT

there should be comma as decimal separator and dot as thousand separator

Re: handle separator in string variable

nabheetscn — Mon, 25 Oct 2010 07:04:17 GMT

This can be handled via user setting default also..or use write to statment press f1 and you will be able to find..

Nabheet

Re: handle separator in string variable

Former Member — Mon, 25 Oct 2010 07:28:09 GMT

HI,

U can set the user profile.

Goto System~~->User Profile~~->Own Data--->Defaults.

Here u can set the "Decimal Notation" field.

Re: handle separator in string variable

Former Member — Mon, 25 Oct 2010 07:44:50 GMT

it should not be based on user notation

Re: handle separator in string variable

Former Member — Mon, 25 Oct 2010 07:46:45 GMT

Hi Prema,

What is the purpose of using the TRANSLATE? Are you using it to convert to the correct separator format or for some other purpose.

Regards,

Immanuel.

Re: handle separator in string variable

Former Member — Mon, 25 Oct 2010 08:00:41 GMT

im using it to convert to he correct format

Re: handle separator in string variable

nabheetscn — Mon, 25 Oct 2010 08:00:57 GMT

use write to with edit mast....or u can use set county command before write

nabheet

Re: handle separator in string variable

Former Member — Mon, 25 Oct 2010 08:21:23 GMT

Hi,

try this:


DATA: STR1 TYPE STRING.
DATA: DMBT TYPE DMBTR.
STR1 = '149,637.81'.
TRANSLATE STR1 USING ', . '.
CONDENSE STR1 NO-GAPS.
DMBT = STR1 / 100.
WRITE: / DMBT.

Regards, Dieter

Re: handle separator in string variable

matt — Mon, 25 Oct 2010 08:39:09 GMT

My telepathy skills are week today. How have your tried using translate? What is your input, and what output do you expect?

It's really important to state your questions clearly, with relevant information. Otherwise the answers you get will be just guesses.

Re: handle separator in string variable

UmaArjunan — Mon, 25 Oct 2010 08:58:23 GMT

You are trying to Translate the workarea / variable containing the amount and quantity filed.

What is the output format you require in those fields for translation. ?

Give example of your output which is needed after translate ?

Thanks

ABAP Dev

Re: handle separator in string variable

nabheetscn — Mon, 25 Oct 2010 09:14:07 GMT

I tried this code andit works.

 DATA:lv_char TYPE dmbtr.

DATA:lv_char1 TYPE char10.

lv_char = '1210.10'.

  set country 'DE'.

WRITE lv_char TO lv_char1.

WRITE lv_char1.

Nabheet

Re: handle separator in string variable

Former Member — Mon, 25 Oct 2010 09:15:38 GMT

Maybe show us a piece of your code? Field definitions?

Re: handle separator in string variable

Former Member — Tue, 26 Oct 2010 10:56:22 GMT

thanks evryone

I used if conditions and translate and its working nw