topic Re: I need help on Split or anything in Application Development and Automation Discussions

I need help on Split or anything

Former Member — Mon, 15 Mar 2010 13:31:06 GMT

Hi experts

i got a string and one field got values like this.

b = ab_345

b= cvb 234

b=23456

b=sdfg_7892

how can i add infront off all the values v_345 ,v_234,v_23456 and v_7892.

Re: I need help on Split or anything

Former Member — Mon, 15 Mar 2010 13:39:08 GMT

Hi Sandya,

Use FIND OCCURANCE OF '_' in your string. when the search is successful, sy-fdpos will be set its offset. Then delete those many letters from your substring and append v to your _234 etc.

Thanks,

Kiran

Re: I need help on Split or anything

StMou — Mon, 15 Mar 2010 13:39:35 GMT

Hi,

Try this


PARAMETERS P_DATA TYPE STRING.

DATA D_OFFSET TYPE SY-FDPOS.



WRITE : P_DATA, '--->'.

* Search te Character '_' and store position into variable
FIND FIRST OCCURRENCE OF '_' IN P_DATA MATCH OFFSET D_OFFSET.

* REPLACE '_' if found
IF D_OFFSET GT 0 .
  ADD 1 TO D_OFFSET.
ENDIF.

CONCATENATE 'V_' P_DATA+D_OFFSET INTO P_DATA.

WRITE P_DATA.

Rgds

Re: I need help on Split or anything

Former Member — Mon, 15 Mar 2010 13:48:29 GMT

Hi thanks for ur reply but if the space in between the value .its not working

ex: p_data abcde 345

output : v_abcde 345.

i want like this v_345

Re: I need help on Split or anything

Former Member — Mon, 15 Mar 2010 13:55:03 GMT

When the sy-subrc fails, check for SPACE and follow the same logic.

Regards,

Kiran

Re: I need help on Split or anything

StMou — Mon, 15 Mar 2010 13:58:38 GMT

Hi,

you would like replace all character not Equals 0 1 2 3 4 5 6 7 8 9 and put before string 'V_' ?

Rgds

Edited by: stéphane mouraux on Mar 15, 2010 2:59 PM

Re: I need help on Split or anything

Pawan_Kesari — Mon, 15 Mar 2010 14:03:20 GMT

REPLACE FIRST OCCURRENCE OF REGEX '[0-9]' IN lv_string WITH 'v_$&' .

Re: I need help on Split or anything

Former Member — Mon, 15 Mar 2010 16:05:32 GMT

hi ,

try the following code .

data: p_data type string value 'abcde 345'.

data: l_result type string.

data: l_length type i.

data: l_count type i VALUE 0 .

data: l_current_char type c.

data: l_no_number type c value 'X'.

l_length = strlen( p_data ).

WHILE l_count < l_length.

l_current_char = p_data+l_count(1).

if not l_current_char co '0123456789' and

not l_current_char is INITIAL.

REPLACE ALL OCCURRENCES OF l_current_char IN p_data WITH l_no_number.

endif.

add 1 to l_count.

ENDWHILE.

CONDENSE p_data NO-GAPS.

REPLACE ALL OCCURRENCES OF l_no_number IN p_data WITH space.

CONCATENATE 'v_' p_data into l_result.

write l_result.

Regards luigi

Re: I need help on Split or anything

Former Member — Thu, 18 Mar 2010 12:02:06 GMT

REPORT ZTEST.

PARAMETERS P_DATA TYPE STRING.

DATA D_OFFSET TYPE SY-FDPOS.

WRITE : P_DATA, '--->'.

data: len TYPE n,

fr TYPE n.

len = strlen( p_data ).

fr = 0.

do.

if fr le len.

if p_data+fr(1) ca '0123456789'.

fr = fr + 1.

len = len - fr.

CONCATENATE 'V_' P_DATA+fr(len) INTO P_DATA.

exit.

endif.

fr = fr + 1.

ENDIF.

ENDDO.

WRITE P_DATA.