Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 19, 2016 at 12:00 PM

    Hi Mari,

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

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2016 at 12:03 PM

    Hello Mari,

    the escape symbol is #

    BR

    Andreas

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2016 at 02:22 PM

    are you in BW on HANA or BW?

    if it is BW on HANA then you can write SQL

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2016 at 07:13 AM

    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 '*'.

    Add comment
    10|10000 characters needed characters exceeded