Labeling specific features in ArcGIS for Desktop?

Question

In ArcGIS 10.3 for Desktop, I work with this point layer and I want to remove all the Sg & Sgs labels from it:

So I can get this result only:

All the labels are in one field named "field_name" (it is a string type field). I can seperate the data into two fields or export the features with the numbers only.

I prefer to remove it with SQL Expression. I tried this one:

def FindLabel ([field_name]):
  if "Sg" IN [field_name] :
    pass
  return [field_name] 

I am getting this error:

Error 0 no line 0.
SyntaxError: invalid syntax (<string>, line 2)   

Answer 1

Your second line includes the word IN in uppercase and in python it should be lower case in.

Your return line should be inside an else

Possibly better than an in you should just check for the first two characters:

def FindLabel ([field_name]):
    if [field_name][:2] == "Sg" :
        pass
    else:
        return [field_name] 

Answer 2

If you only want to label the feature with it Object ID (the numbers you posted in the second picture), then you need to open the layer properties, navigate to the display tab and select label all features the same way and use the field Object ID form the drop down. Simple as that.