SELECT 'NULL' on a joined table

[nimitz]

Hi all, I have joined a sde feature class to a .txt. The .txt file has several hundred 'NULL' values in the field I want to select from. However, I want to select NON-NULL values. ArcMap won't let me select NULLs. After that I would want to flip the selection set to show every record that has a value.

WINDOWS 10, acrmap 10.8.2

Thx

[JeffHouser · Accepted solution]

Nimitz,

In ArcMap, Selection - Select Attributes, cant you use "field" is not null to select features with non-null values? 

~Jeff

[nimitz]

Dooood!! You 'da man!!😀  Worked like a charm! Now, if I could automate this process...

I owe you a beer!

[RhettZufelt]

You can if you want to use python.

Add Join.

Select by Attributes.

R_