topic Re: Remove '-' from the value in Application Development and Automation Discussions

Remove '-' from the value

Former Member — Wed, 07 Mar 2007 22:53:22 GMT

hi guys

i have a telephone number. it can come in any form like

1-800-222-3333 or

1800-222-3333 or

1 800 222 3333 or

1800 222 3333 or

800-222-3333 or

800 222 3333 or it can be of any other form.

but i need that number in 8002223333. It should not contain any characters or spaces in between and also it should not contain '1' in front of the number. Is there any way we can do it?.

Re: Remove '-' from the value

ferry_lianto — Wed, 07 Mar 2007 22:59:04 GMT

Hi,

You can use TRANSLATE statement.


TRANSLATE WA_PHONE USING '1 '.
TRANSLATE WA_PHONE USING '- '.
CONDENSE WA_PHONE NO-GAPS.

Regards,

Ferry Lianto

Re: Remove '-' from the value

amit_khare — Wed, 07 Mar 2007 23:00:27 GMT

Replace all occurrance of '-' in v_phone from ' '.

Condese v_phone.

Regards,

Amit

Re: Remove '-' from the value

Former Member — Wed, 07 Mar 2007 23:00:56 GMT

Try this code


DATA: tot_digits TYPE i.

TRANSLATE phone_number USING '- '.
CONDENSE phone_number NO-GAPS.
tot_digits = strlen( phone_number).
IF tot_digits = 11 AND phone_number+0(1) = '1'.
  SHIFT phone_number LEFT.
ENDIF.

Re: Remove '-' from the value

Former Member — Wed, 07 Mar 2007 23:04:20 GMT

value = '1800-12-1233-00'.

if value+0(1) = '1'.

value+0(1) = space.

endif.

translate value using '- '.

condense value no-gaps.

Regards,

Navneet

Re: Remove '-' from the value

Former Member — Thu, 08 Mar 2007 21:05:04 GMT

Just remember that if you are using this TRANSLATE WA_PHONE USING '1 ' statement will replace all 1s in the phone number in the string and you will get wrong results. If I have phone number 12133144111, the above statement after CONDENSE will give me 23344 and I am sure that is not what you want. You just want to replace the first 1 only.