Share via

Search Query is not filtering special characters

Sajith Gopalakrishnan Hema 1,056 Reputation points
2023-07-07T15:28:52.3733333+00:00

Search Query using @pnp/sp and refinables are mapped to list column. If there is special characters in the list column, it is not detecting.

For example, the result is same for the list column 2AA06 and 2AA06-

Tried prevent special characters in list item using list validation. However, unable to do for other columns due to the limitation.

Microsoft 365 and Office | SharePoint | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 31,686 Reputation points Microsoft External Staff
    2023-07-10T09:17:31.0833333+00:00

    Hi @SGH ,

    You can try by creating a calculated column that removes special characters from the original column:

    =SUBSTITUTE([Original Column],"-","")

    This formula will remove all dashes from the original column. You can modify it to remove other special characters as well. Once you create the calculated column, you can map the refinable to it instead of the original column.

    Of course, you can also achieve it through third-party tools.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.