Return search results with and without accents

[HFG]

Hi, 

I am working on a App in French so there are various characters with accents (éèàû..). I have a search box set up to filter a gallery. I would like the search results to return words with accents even if the person types it in the search box without, e.g. if they search "Petrochimie" and the name in the gallery is "Pétrochimie" the result is still returned, is this possible? 

Thanks in advance for your help. 

[MadAusi]

Hello,

thanks a lot for this solution wich seems to work.

But can you help me, cause i dont know where to put exactly this formula .

Waiting for an Help

Thanks

MadAusi

[HFG]

Hi @MadAusi 

You would put the formula where the text is that you're using to search, it wraps around your search text. So something like this:

Search(
      Table/CollectionName
           ,Subsitute Formula with Search Text
,Table/Collection Column to search in 
)

Hope that helps