04-09-2009 3:35 AM
Hi,
I need to find the Roles which contains S_TCODE value as *.When I tried on SUIM & SE16(AGR_1251).It takes * as Wild Card Value and It displaying all the Roles.
Even I tried '' and "" also.But I didnt get the correct value.
Kindly help in sorting out this problem.
Regards
Karthika
04-09-2009 4:02 AM
Dear Karthika,
Try giving #* or #** for the values of S_TCODE and run it.
Regards,
04-09-2009 4:02 AM
Dear Karthika,
Try giving #* or #** for the values of S_TCODE and run it.
Regards,
04-09-2009 4:07 AM
04-13-2009 10:18 AM
Hi Lakshmi ,
Could you please tell me what is the difference in giving * alone and or giving # or #* in place of *
Regards
Kanti
04-13-2009 10:33 AM
In report selections * will look for any value, #* 'escapes' the star and will look for the value , #* 'escapes' the first star and will look for any value starting with a *.
This escaping is found in almost every system/programming language to be able to work with characters that have special meaning to the system.
In Excel it's the ~ (tilde) symbol. You can try this to see the difference:
Fill an empty sheet from cell A1 thru A5 with:
a
b
c
d
*
Now look at the different outcome if you type these formulas in another cell:
=COUNTIF(A1:A5;"*") to look for anything
=COUNTIF(A1:A5;"~*") with the star escaped.
04-13-2009 10:37 AM