topic Re: a question on string manipulation in Application Development and Automation Discussions

a question on string manipulation

Former Member — Wed, 26 Sep 2007 09:39:20 GMT

hi guys,

one question on string manipulation need your help here.

source in SAP

doc part location

1 A u1

2 B u1,u2

3 C u1,u2,c1-c3

desire report output

doc part location

1 A u1

2 B u1

2 B u2

3 C u1

3 C u2

3 C c1

3 C c2

3 C c3

thanks.

Re: a question on string manipulation

Former Member — Wed, 26 Sep 2007 09:46:02 GMT

hi boon,

a = 1 A u1

b = 2 B u1,u2

c = 3 C u1,u2,c1-c3

d = ' '.

2 B u1 -

> b+0(4).

2 B u2 -

> REplace u1 in b with d. condense b no-gaps.

3 C u1 -

> c+0(4)

3 C u2 -

> c0(2), c4(2). concatenate both.

3 C c1 -

> c0(2), c6(2). concatenate both.

Please reward if helpful.

Thanks.

Re: a question on string manipulation

Former Member — Wed, 26 Sep 2007 09:51:44 GMT

hi Shori,

i should have explain it more clearly.

the source file are stored in a internal table with 3 columns (doc,part,location). how are we going to decide when come across the ',' and '-' and split it into new rows?

thanks.

Re: a question on string manipulation

Former Member — Wed, 26 Sep 2007 09:59:55 GMT

hi,

there is an option in abap as search.

Just use it for search , and -.

U have to search only the location field.

by using If statement u can finish the scenario.

Please reward if helpful.

Re: a question on string manipulation

Former Member — Wed, 26 Sep 2007 10:02:55 GMT

Hi,

try this

loop at itab.

split itab-location into loc1, loc2,loc3 seperated by ',' .

In loc1, loc 2, loc3,

search for '-'

if found get the sy-fdpos.

from sy-fdpos-1 u will get C1

from sy-fdpos+-1 u will get C3

then u can populate as u required.

endloop.

Reward if useful.

Regards,

Bindu.

Re: a question on string manipulation

Former Member — Wed, 26 Sep 2007 10:55:43 GMT

Check the code below, i hope it serves your pupose

data:

begin of itab occurs 0,

doc,

part,

location(255),

end of itab,

begin of loc occurs 0,

location(255),

end of loc,

itab2 like table of itab with header line.

itab-doc = '1'.

itab-part = 'A'.

itab-location = 'u1'.

append itab.

itab-doc = '2'.

itab-part = 'B'.

itab-location = 'u1,u2'.

append itab.

itab-doc = '3'.

itab-part = 'C'.

itab-location = 'u1,u2,c1,c2,c3'.

append itab.

loop at itab.

itab2 = itab.

split itab-location at ',' into table loc.

loop at loc.

itab2-location = loc-location.

append itab2.

write:/ itab2.

endloop.

Reward points if useful, get back in case of query...

Cheers!!!

Re: a question on string manipulation

Former Member — Tue, 09 Oct 2007 14:35:44 GMT

hi,

sorry for late reply...

two question here need your advice.

1.from sy-fdpos-1, how i get the content (c1)?

2.in this case we have c1 and c3, other cases may be c1 and c5. how would the program know the range (c2, or c2~c4) to be populated here?

thanks.

Re: a question on string manipulation

Former Member — Wed, 10 Oct 2007 04:51:19 GMT

Did u see my previous post, it itself handles the string irrespective of the range(dynamic), hope it is what u r looking for.

Reward points if useful, get back in case of query...

Cheers!!!

Re: a question on string manipulation

Former Member — Wed, 10 Oct 2007 10:14:15 GMT

yes, i tried out your code and it's working find when the location is separate by ','.

only thing is how about the case d1-d5 in the internal table?

how are we going to know how many number to fill in between d1~d5 at runtime, it can be any number here.

attach a sample code here:

&----

*& Report ZTEST20071009 *

*& *

&----

*& *

&----

REPORT ZTEST20071009 .

types: begin of itab,

doc(1),

part(1),

location(255),

end of itab.

types: begin of iloc,

location(255),

end of iloc.

data: i_itab type table of itab,

w_itab type itab,

i_loc type table of iloc,

w_loc type iloc,

i_itab2 type table of itab,

w_itab2 type itab.

w_itab-doc = '1'.

w_itab-part = 'A'.

w_itab-location = 'u1'.

append w_itab to i_itab.

w_itab-doc = '2'.

w_itab-part = 'B'.

w_itab-location = 'u1,u2'.

append w_itab to i_itab.

w_itab-doc = '3'.

w_itab-part = 'C'.

w_itab-location = 'u1,u2,c1,c2,c3,d1-d5'.

append w_itab to i_itab.

loop at i_itab into w_itab.

itab2 = itab.

w_itab2-doc = w_itab-doc.

w_itab2-part = w_itab-part.

split w_itab-location at ',' into table i_loc.

search w_itab-location for '-'.

if sy-subrc EQ 0.

w_loc = sy-fdpos - 1.

append w_loc to i_loc.

w_loc = sy-fdpos + 1.

append w_loc to i_loc.

endif.

split itab-location at ',' into table loc.

loop at i_loc into w_loc.

w_itab2-location = w_loc-location.

append w_itab2 to i_itab2.

write:/ w_itab2-doc,w_itab2-part,w_itab2-location.

endloop.

loop at loc.
itab2-location = loc-location.
append itab2.
write:/ itab2.
endloop.

endloop.

Re: a question on string manipulation

Former Member — Wed, 10 Oct 2007 10:53:20 GMT

Run the code below for range...

REPORT ZTRIP_TEST.

data:

begin of itab occurs 0,

doc,

part,

location(255),

end of itab,

begin of loc occurs 0,

location like itab-location,

end of loc,

range_start like itab-location,

range_end like itab-location,

itab2 like table of itab with header line.

itab-doc = '1'.

itab-part = 'A'.

itab-location = 'u1'.

append itab.

itab-doc = '2'.

itab-part = 'B'.

itab-location = 'u1,u2,d1-d5'.

append itab.

itab-doc = '3'.

itab-part = 'C'.

itab-location = 'u1,u2,c1,c2,c3'.

append itab.

loop at itab.

itab2 = itab.

split itab-location at ',' into table loc.

loop at loc.

search loc-location for '-'.

if sy-subrc eq 0.

split loc-location at '-' into range_start range_end.

itab2-location = range_start.

append itab2.

write:/ itab2.

while itab2-location ne range_end.

itab2-location1(1) = itab2-location1(1) + 1.

append itab2.

write:/ itab2.

endwhile.

else.

itab2-location = loc-location.

append itab2.

write:/ itab2.

endif.

endloop.

Reward points if useful, get back in case of query...

Cheers!!!

Re: a question on string manipulation

Former Member — Thu, 11 Oct 2007 01:34:09 GMT

you're great!