ScottHunterQrew Member23 days agoExtract Everything Left of 3rd Underscore from Right Hello all, I am working on building a formula that will extract everything left of the 3rd underscore from the right. Sample date: 139_EDWARDS_DR_NW_VIENNA_VA_20176 Desired result: 139_EDWARDS_...Show More
MarkShnier__YouQrew Legend23 days agoThis tests OK for me.NotRight(NotRight(NotRight([My Underscored String],"_"),"_"),"_")