[GIS] How to select features where attribute is not NULL

qgisselect-by-attribute

I have an OS AddressBase shape file. One of the attributes is 'paoText'. It is either a text string like 'Anchor House' or is NULL.

I want to extract all the records where there is a text string i.e. the attribute is not NULL.

I have tried Advance search with paoText = NULL with the idea of inverting the result to get all those records that contain text i.e. a property name, but my search returns nill records.

I know there are records with NULL in that attribute because I can see them. What am I doing wrong please?

Best Answer

Have you tried

paoText is NULL

paoText is not NULL

Related Solutions

QGIS – How to Search Text String and Select Item in QGIS

if the attribute is called ROAD NAME, the query should be

"ROAD NAME" LIKE '%1%'

[GIS] Select features from attribute table and then create a new field with the selected attribute data

Use the field calculator. Essentially you are asking the field calculator to read the values from one column and input them in the new fields. Set "use selected features" and "update existing" if you have already created the target column. In the tree of options to the lower left, you expand the bottom branch and double click on the name of the field as the source. With luck, this will automagically put that field name into the dialog box, surrounded by double quotes.

I think what you are asking to be done, is the most elementary thing the field calculator does so it may be a bit daunting with all the possibilities.

Also there is a plugin called something like "Quick Multi Attribute Edit/Update" which might be of use in similar circumstances.

Best Answer

Related Solutions

QGIS – How to Search Text String and Select Item in QGIS

[GIS] Select features from attribute table and then create a new field with the selected attribute data

Related Question