Solr Query : Search for fields containing only white spaces

Question

How do i write a solr query to search for a field with only white spaces in it ? For example

{
    "phone_number":"Airtel",
    "smstype":1,
    "phone_status":-1,
    "user_hash":"52565f64ba3e8df1aa",
    "contact_name":" ",
    "snaptype":1,
}

If you notice the contact_name field, it is just two spaces, how do i filter out records which contains only spaces for a particular field ?

score 0 · Answer 1 · edited May 23 '17 at 10:34

0

I have answered similar question here.

In the SolrQuerySytax page they says that you can use the following query to find all empty queries.

-field:[* TO *] finds all documents without a value for field

edited May 23 '17 at 10:34

Community

1
1

answered Jul 10 '12 at 13:30

Parvin Gasimzade

25,180
8
56
83

The question is not about retrieving documents without a value for a specific field, but with only whitespaces for a specific field. – javanna Jul 10 '12 at 14:00

score 0 · Answer 2 · edited May 23 '17 at 11:55

0

I think this could be achieved by using a regex query (I am not regex expert but 'only whitespaces' is pretty easy and common).

See this for detailed info on regex support in solr/lucene

edited May 23 '17 at 11:55

Community

1
1

answered Jul 10 '12 at 14:06

Persimmonium

15,593
11
47
78

score 0 · Answer 3 · answered Jul 10 '12 at 14:31

0

Adding to Persimmonium's answer - the following query should do the trick.

In addition to regex you will also need to escape for the space.

contact_name:"\ "*

answered Jul 10 '12 at 14:31

user1452132

1,758
11
21

score 0 · Answer 4 · answered Jul 11 '13 at 11:25

0

Sorry for being a little late. A regex to find whitespace is very easy to find. You should also pay attention the tokenizer you are using. Some tokenizers will strip off the whitespace and leave the field empty.

answered Jul 11 '13 at 11:25

Omar Jaafor

161
3
12

Solr Query : Search for fields containing only white spaces

4 Answers4