topic Re: Code to delete in Application Development and Automation Discussions

Code to delete

Former Member — Thu, 29 Mar 2007 18:23:48 GMT

Hi,

I need to check field 'f1' from itab and delete the character '/'.

I must delete where itab-f1 = '/'.

suppose itab-f1 = abc/def

it should show itab-f1 = abcdef

How should I write the code?

Message was edited by:

ramana peddu

Re: Code to delete

Former Member — Thu, 29 Mar 2007 18:27:45 GMT

Hi,

Please try this.


...
TRANSLATE ITAB-F1 USING '/ '.
CONDENSE ITAB-F1 NO-GAPS.
...

Regards,

Ferry Lianto

Re: Code to delete

Former Member — Thu, 29 Mar 2007 18:28:23 GMT

Try this code.

LOOP AT itab.
  REPLACE ALL OCCURANCES OF '/' IN  itab-f1 WITH SPACE.
  CONDENSE itab-f1 NO-GAPS.
  MODIFY itab.
ENDLOOP.

Re: Code to delete

Former Member — Thu, 29 Mar 2007 18:29:38 GMT

Hi,

Use this code.

REPLACE '/' with SPACE into itab-f1.

CONDENSE itab-f1 NO-GAPS.

Regards,

Re: Code to delete

Former Member — Thu, 29 Mar 2007 18:30:07 GMT

hi ramana,

instead of using delete stmt u can try split command for ur purpose.

Regards...

Arun.

Reward points if useful.

Re: Code to delete

Former Member — Thu, 29 Mar 2007 18:30:40 GMT

HI..,

if ur field is of type C,

then it will solve ur problem..

loop at itab.

replace all occurrences of '/' in itab-f1 with ' '.

condense itab-f1 with no-gaps.

endloop.

regards,

sai ramesh

Re: Code to delete

Former Member — Thu, 29 Mar 2007 18:33:16 GMT

Hi Ramana,

Use TRANSLATE statement inside LOOP...ENDLOOP.

LOOP AT ITAB.

TRANSLATE ITAB-F1 USING '/ '.

CONDENSE ITAB-F1 NO-GAPS.

MODIFY ITAB INDEX SY-TABIX.

ENDLOOP.

Thanks,

Vinay