topic Re: Search String case sensitive in Application Development and Automation Discussions

Search String case sensitive

Former Member — Tue, 21 May 2013 12:23:49 GMT

Hi Guys,

I have a question. I would like to see if two strings matches. It should be case sensitive. One can contain wildcard * or +.

I have found the pradicate matches(val = , ...) unfortunately i cannot use it because my system is old. I have also tried with CP but it is unfortunately not case sensitive.

Please help me.

Ex. String A should match string B.

1. A = Partnership , B = Partnership => match

2. A = 'PartnershiP' , B = Partnership => no match

3. A = *artne* , B = Partnership => match

4. A = 'PartNership' , B = 'Partnership' => no match

Can I use FIND regex in ... or FIND all Occurences?

I dont know how to express regex because the * or + can appear at any place in the string.

Please help me to find the best solution. Thanks.

Thanks.

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 12:35:12 GMT

Hi Maria,

TRANSLATE string A TO UPPER CASE.

TRANSLATE string B TO UPPER CASE.

Now compare both.

Regards,

Mordhwaj

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 12:37:29 GMT

Hi,

Hope this will clear your doubts on how to use these variable .For case sensitive search

you can use #

Character	Used to
*	Match any sequence of characters.
+	Match any single character.
#	Interpret the next character literally.

Table Using Characters

Statement	True When
v1 CP 'A+C'	v1 contains "a" in the first position and "c" in the third. Either character can be in upper- or lowercase. Any character can appear in the second position.
v1 CP 'Ab'	The string "ab" occurs anywhere within v1. Either character can be in upper- or in lowercase.
v1 CP '#A#b'	v1 contains a capital A followed by lowercase b.

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 12:43:05 GMT

They should be case sensitive. This would not work.

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 12:45:56 GMT

If I understand. I need to write a method that add # in front of all the character in the searchstring.

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 12:53:26 GMT

Hello Maria,

Use the following link.

https://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3516358411d1829f0000e829fbfe/content.htm

Hope it would be helpful...

Regards,

Navneet

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 13:04:41 GMT

Hi Maria,

Try this example:

DATA:

lv_string1 TYPE string VALUE 'Satish',

lv_string2 TYPE string VALUE 'SatisH'.

FIND REGEX lv_string1 IN lv_string2.

IF sy-subrc = 0.

WRITE /'Matches'.

ELSE.

WRITE /'Do not matches'.

ENDIF.

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 13:14:08 GMT

lv_string1 should contain * or + and the search should be case sensitive.

I have tried it. It doesnt work.

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 13:38:30 GMT

Thanks but I have already tried CP (Contains Pattern). It didnt work because it was not case sensitive.

Re: Search String case sensitive

Clemenss — Tue, 21 May 2013 14:02:14 GMT

Hi Maria,

what's the problem? Regex is case sensistive if not otherwise specified.

FIND REGEX 'PartnershiP' IN 'Partnership' . "SY-SUBRC = 4, no match
FIND REGEX 'Partnership' IN 'Partnership' . "SY-SUBRC = 0, match
FIND REGEX 'artner' IN 'Partnership' . "SY-SUBRC = 0, match

Regards

Clemens

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 14:15:22 GMT

You are right. My question is: how do I express the REGEX with + or * in it. It doesnt work. The search string is not always fully given. I may have 'Partner*' or '*Partne*ip' .

Thanks

Re: Search String case sensitive

PeterJonker — Tue, 21 May 2013 14:18:17 GMT

I think you need to be more specific.

especially when you state: " * or + can appear at any place in the string."

That more or less means everything is possible. Basically you are saying Find regex * in anystring. Which will Always find a match.

You will have to state what are you looking for within a string. Which part is static and which part you want to use wildcards for.

A simple (real) example can clarify a lot.

Furthermore check the program DEMO_REGEX_TOY in your SAP system, you can try around with this program.

And a last remark is that you are referring to wild card +, but I don't think you can use that in regular expressions. Wildcxards are . (dot) for a single character and * for zero or more of the SAME characters.

FIND regex '.artne.' in 'Partner' RESPECTING CASE. would give a match

while

FIND regex '.artne.' in 'ParTner' RESPECTING CASE. would not return a match.

FIND regex '.ar.*' in 'Partner' RESPECTING CASE. would give a match

while

FIND regex '.art.*' in 'ParTner' RESPECTING CASE. would not return a match.

Re: Search String case sensitive

Former Member — Tue, 21 May 2013 15:55:03 GMT

Hi,

There are standard FMs available to convert case into one another. Better use them, as they work for different languages too.

Search for such FM using keywords, Translate, Upper etc., in SE37.

One such FM is TERM_TRANSLATE_TO_UPPER_CASE. If you dont find this, search for anyother rather than using TRANSLATE statement.

Regards

Karthik

Re: Search String case sensitive

Former Member — Wed, 22 May 2013 04:33:53 GMT

Hi,

Try this code:

DATA: matcher TYPE REF TO cl_abap_matcher,

match TYPE c LENGTH 1.

matcher = cl_abap_matcher=>create( pattern = 'S(.*)ish'

ignore_case = ''

text = 'Satish' ).

match = matcher->match( ).

IF match = 'X'.

WRITE /'Matches'.

ELSE.

WRITE /'Do not matches'.

ENDIF.

Re: Search String case sensitive

Former Member — Wed, 22 May 2013 07:09:56 GMT

I like regex, so here is a working snippet for you using regex.

For wildcard * , regex equivalent is .*

REPLACE statement is used to replace * with regex wildcard.

In case your search string has real asterisk instead of wildcard, you need to replace * with \*

*1. A = Partnership ,  B = Partnership  => match
 PERFORM matching USING 'Partnership' 'Partnership'.
 *2. A = 'PartnershiP' ,  B = Partnership  => no match
 PERFORM matching USING 'PartnershiP' 'Partnership'.
 *3. A = *artne* ,  B = Partnership  => match
 PERFORM matching USING '*artne*' 'Partnership'.
 *4. A = 'PartNership' ,  B = 'Partnership'  => no match
 PERFORM matching USING 'PartNership' 'Partnership'.
 
 *&---------------------------------------------------------------------*
 *&      Form  matching
 *&---------------------------------------------------------------------*
 FORM matching USING a TYPE string
                     b TYPE string.
   DATA lv_result TYPE string.
 
   REPLACE ALL OCCURRENCES OF '*' IN a WITH '.*'.
   FIND FIRST OCCURRENCE OF REGEX a IN b.
   IF sy-subrc EQ 0.
     lv_result = 'match'.
   ELSE.
     lv_result = 'no match'.
   ENDIF.
   WRITE:/(30) a,
          (30) b,
          lv_result.
 
 ENDFORM.                    "matching