Calculate EGT_ID from Explorer field in Observations survey if field added after data began to be collected:

SUBSTRING(explorer,40,CHAR_LENGTH(explorer)-40)