Search ignoring whitespaces


#1

How can I perform a query ignoring the whitespaces of one attribute ?

The use-case scenario is fairly simple: we have phone numbers indexed as strings and with a wide variety of formats ("123456789", "123 456 789", "123-456789", "111222333 OR 123456789", ...). A search query performed with the "simplified number" (e.g., 123456789) should return all the matches that contain that sequence of characters, regardless of whitespaces (and ideally, other characters like "/"). For the given examples, it would return all those records.

It seems like a situation where one would use an analyzer to split the indexed attributes in terms, and perform a query with "joined terms", but I'm not really sure this is a default behaviour of any analyzer or how to apply/define it.

Thanks


(system) #2