topic Re: Remove (-) from amount value 1000- in Application Development and Automation Discussions

Remove (-) from amount value 1000-

Former Member — Fri, 24 Apr 2009 11:47:55 GMT

Hi Experts,

We need to check if a value contains ' - ', if so, remove the ' - ' sign and display the value. Can anyone guide on how to achieve this?

Thanks a lot.

Former Member — Fri, 24 Apr 2009 11:50:36 GMT

Hi Tush Mangad,

Multiply it with -1

if v_value < 0.
v_value = -1 * v_value.
endif.

Regards,

ravi

Edited by: Ravi Kanth Talagana on Apr 24, 2009 1:51 PM

amit_khare — Fri, 24 Apr 2009 11:52:26 GMT

Just use 'NO-SIGN' when moving to the output. You don't have to check for the sign then.

Former Member — Fri, 24 Apr 2009 11:58:45 GMT

Hi,

You can use ABS

EXAMPLE:

w_wrbtr = ABS( w_wrbtr ).

regards

Krishna

kanishakgupta1 — Fri, 24 Apr 2009 12:03:58 GMT

replace all occurences of '-' in amount with ' '.

Former Member — Fri, 24 Apr 2009 12:11:52 GMT

v_notification = '2001234-'.

if v_notification ca '0'.

REPLACE ALL OCCURRENCES OF '-' IN V_NOTIFICATION with ' '.

endif.

Thanks

Naveen.

Former Member — Fri, 24 Apr 2009 13:53:49 GMT

HI naveen,

The statement

"if v_notification ca '0'. " will check if v_notification contains any 0 and does not check if the value is negative.

It should be

if v_notification ca '-'. instead.

Regards,

Ravi Kanth Talagana