Remove Special Characters - Azure AI Search

Question

To remove or ignore special characters in a search query for an Azure Cognitive Search index.

(Json) Query:

{

  "search": "*",

  "queryType": "semantic",

  "semanticConfiguration": "resource-semanticsv2",

  "captions": "extractive",

  "answers": "extractive|count-3",

  "queryLanguage": "en-US"

}

 

Result:

    "@search.score": 1,

      "id": "1198",

      "Name": "$$$Benson, Carl",

      "User_role": null,

      "Job_title": null,

      "Manager": null

 

wanting to remove $ and still displaying the Name?!

Answer 1

@Davis, Vincent , Based on my understanding of your scenario description, you may try using a custom analyzer at index time that removes or replaces special characters in your indexed fields. Tutorial: create a custom analyzer - Azure AI Search | Microsoft Learn.

If you haven't tried this already, you may use a character filter that removes or replaces the "$"

You may also use regex, something like this:  "search": "/\\$+Benson, Carl/"

Kindly let us know how it goes I'll follow-up with you further.