topic Re: Replace comma and period from a variable. in Application Development and Automation Discussions

Replace comma and period from a variable.

Former Member — Wed, 08 Oct 2014 11:53:06 GMT

Hi all.

I am having a variable with data 452,42.53 which i have to convert to 452.42,53.

Kindly advice how to get this through program.

Rohini

Re: Replace comma and period from a variable.

former_member249399 — Wed, 08 Oct 2014 12:05:56 GMT

try REPLACE ALL OCCURRENCES.

Re: Replace comma and period from a variable.

Former Member — Wed, 08 Oct 2014 12:09:18 GMT

Hi Rohini Waghel ,

I think you want to convert the currenyc amount or quantity as per the user decimal format.

You can use write statment as shown below for currecy and quantity fields. Define it as chatacter type. This will solve your issue.

WRITE wf_amount TO wf_amount1 CURRENCY 'EUR'.

WRITE wf_quantity TO wf_quantity1 UNIT 'EKPO-MENGE'.

Regards,

Pravin

Re: Replace comma and period from a variable.

Former Member — Wed, 08 Oct 2014 12:11:03 GMT

Try to do something like this:


DATA: v_kbetr TYPE konv-kbetr ,
      v_wrbtr TYPE c LENGTH 16.

v_kbetr = '45242.53'.
v_wrbtr = v_kbetr.

CONDENSE v_wrbtr NO-GAPS.
TRANSLATE v_wrbtr USING '.,'.

Re: Replace comma and period from a variable.

Former Member — Wed, 08 Oct 2014 12:13:51 GMT

Hi Rohini Waghel,

I guess for currency-conversion should be a conversion-exit. Try searching the SE37 for CONVERSION_EXIT*.

Kind regards,

Benjamin