Help with querying text fields that contain decimal values, ie 2000 = 2000.00

[DaveRowley]

Hello, I'm having difficulty trying to find decimal values in a text field without specifying the decimal part. I'd like a query for '2000' to also include results from fields that contain '2000.00', and preferably ignore separating commas as well, ie 2000 = 2,000 = 2000.00

The field is mapped as text, with a 'sub field' of .english for language analysis and english stop words.

Any advice or reading material welcome
-Dave

[constancecchen (Constance Chen)]

Hey Dave! If this is for App Search, you could try creating a synonym for the strings 2000, 2000.00, and 2,000. Check the below screenshot for an example:

Hope that helps!