Skip to Content
0

Search for "*" as a literal character in SAP BW (display data)

Oct 19, 2016 at 10:33 AM

113

avatar image
Former Member

Hello,

I am displaying data from SAP BW (transaction code RSA1) and at the selection screen of the InfoProvider I want to check if a characteristic includes the character "*" in the string values. Can you please inform me what is the escape character for special characters? How can I search if the asterisk in included in a text without it being used as a wildcard?

Thank you very much

10 |10000 characters needed characters left characters exceeded
Former Member

Hi guys,

Do you have any other suggestions regarding the above topic?

Thank you

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Frédéric Cincet Oct 19, 2016 at 12:00 PM
0

Hi Mari,

'#' is the escape character. Searching for '*#**' will return all the values containing the character '*'

Regards,

Frederic

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 19, 2016 at 12:03 PM
0

Hello Mari,

the escape symbol is #

BR

Andreas

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Oct 19, 2016 at 02:22 PM
0

are you in BW on HANA or BW?

if it is BW on HANA then you can write SQL

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 21, 2016 at 07:13 AM
0

Hello,

Thank you for your replies. I'm using BW (not BW on HANA). I have tried '#' as the escape symbol ('*#**') but the results return everything that includes '#' instead of '*'.

Share
10 |10000 characters needed characters left characters exceeded