Skip to Content
avatar image
Former Member

Fuzzy Search for alphanumeric content

Hi Experts,

I have implemented fuzzy search in HANA on the material short and long description texts. There is a scenario where if we search alphanumeric content it splits the entered search text and then searches individually for those.

Eg: I search for 25MM but it fetches 25 separately and MM separately instead of searching for 25MM as a single word.

Please suggest how can I resolve this issue.

Regards,

Sakshi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 15, 2015 at 07:13 PM

    Hello Sakshi,

    do you do a phrase search using double quotes? Check the help here - paragraph "Reserved Words and Special Characters in the Search String": The CONTAINS() Predicate - SAP HANA Fuzzy Search Reference - SAP Library

    Best Regards,

    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 07:38 AM

    Hi Sakshi,

    Try using different variants of similar calculation mode

    eg: CONTAINS(column_name, 'search_string', FUZZY(0.8,'similarCalculationMode=compare')) 


    other modes are similarCalculationMode=search, similarCalculationMode=substringsearch to achieve results based on your use case.


    Regards

    Anil

    Add comment
    10|10000 characters needed characters exceeded