topic Re: String comparision and matching in Application Development and Automation Discussions

String comparision and matching

Former Member — Tue, 08 Jan 2013 12:20:55 GMT

Dear Experts,

I have a table in which i have materials and material description field.

I have to compare the material description with the description entered by the user and if the material description in the table contains any

matching word that is entered by the user then that material have to be considered .

For eg;-

ITAB:-

MATNR MAKTX

1000002 arti goods

1000003 ZACT-ALPRAZOLAM ip

1000004 ZACT ABCD

and user enters description as ZACT-ALPRAZOLAM USP

now i want to compare the description in the table matching the description entered by the user and in the above case i want to consider

material number .. 1000003 and 1000004 as it contains at least one word of the description entered by the user..

Regards,

Pavan

Re: String comparision and matching

Venkat_Sesha — Tue, 08 Jan 2013 12:24:05 GMT

Have you done any research before posting?

Please tell us that what you have done. Since Requirement dumping is against Forum Rules

Re: String comparision and matching

RaymondGiuseppi — Tue, 08 Jan 2013 12:33:48 GMT

So you have to

Split the input text to identify individaul words
Buil a range table to check if material text is like or contains those words
Use this range in selection from database or loop at an internal table already loaded
Use F1 on Abap source editor
Read the Rules of Engagement

Regards,

Raymond

Re: String comparision and matching

Former Member — Tue, 08 Jan 2013 12:34:26 GMT

Hi,

I have looped at itab and tried to get the result using CP operator and CS operator.

but it didnt worked..

{Code}

LOOP AT it_makt INTO wa_makt.
IF wa_makt1-maktx CP wa_makt-maktx.

*    IF wa_makt1-maktx CS wa_makt-maktx.
       IF sy-subrc = 0.

       ENDIF.
     ENDIF.
   ENDLOOP.

{Code}

Re: String comparision and matching

former_member392866 — Tue, 08 Jan 2013 12:36:04 GMT

Pavan,

split user enters description by spaces and move to temporary variables like v_temp1,

v_temp2,v_temp3,v_temp4.

loop itab into wa.

if wa-maktx cs v_temp1 or v_temp2 or v_temp3.

get ur record and store in temp variable like v_mara.

exit.

endif.

endloop.

if v_mara is initial.

message 'description not found in the table' type 'e'.

else

write : v_mara.

endif.

Thank you.

Regards,

BALAJI.

Re: String comparision and matching

Venkat_Sesha — Tue, 08 Jan 2013 12:47:29 GMT

Simply you can achieve this with the Keyword Search String.

Dont make things complex.

Check my example below.

LX_LINES Like line of your ITAB-FIELD.

LV_ABC is the value that use has entered.

Search LX_LINES For LV_ABC. Do F1 on this.

Hope this helps

Re: String comparision and matching

Former Member — Wed, 09 Jan 2013 10:28:42 GMT

Hi,

Also regular expression might help you.

Following your example, you would only need to find all occurences of (ZACT|ALPRAZOLAM|USP) in table itab...

Kr,

Manu.

Re: String comparision and matching

Former Member — Tue, 15 Jan 2013 10:45:27 GMT

Done ..

{Code}

SPLIT wa_makt1-maktx

          AT space INTO TABLE it_txt.   " It_TXT holds the description of matnr given by user
   LOOP AT it_makt INTO wa_makt.
     LOOP AT it_txt INTO wa_txt.
       SEARCH wa_makt-maktx FOR wa_txt-str.
       IF sy-subrc = 0.
         wa_data-matnr = wa_makt-matnr.
         wa_data-maktx = wa_makt-maktx.
         APPEND wa_data TO it_data.
       ENDIF.
       CLEAR: wa_txt, wa_data.
     ENDLOOP.
     CLEAR: wa_makt.
   ENDLOOP.

{Code}

Thanks all..