Azure AI Search token filter equivalent to Multiplexer in ElasticSearch

Hi @SnehaAgrawal-MSFT

What I did in Elasticsearch was using multiplexer to emit more tokens for searching money (type in SQL Server) fields.

For example:

1. 1234.56 in database
   1. if you search 1,234.56, it should return
   2. if you search 1234.56, it should return
   3. if you search 1234, it should not return
   4. Otherwise, it should not return
2. 1234.00 in database
   1. if you search 1,234, it should return
   2. if you search 1,234.00, it should return
   3. if you search 1234, it should return
   4. if you search 1,234.00, it should return
   5. if you search 1234.00, it should return
   6. Otherwise, it should not return

PatternReplace can fulfill the #1 example, we could replace the "," to empty string.

However, for the #2 example, it's not simply replace the "," but also ".00" (#2.a and #2.c). And we need to keep the ".00" token for #2.b, #2.d and #2.e. That's why we need to emit the tokens.

Do we have any solution to achieve this?

Regards,

Jay