ScottHunterQrew Member6 months 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 Legend6 months agoThis tests OK for me.NotRight(NotRight(NotRight([My Underscored String],"_"),"_"),"_")
Related ContentExtract Date and Comment from prepend log entry fieldExtracting multiple substrings from a text stringExtract Text Between 2 special charactersHelp extracting text between unique characterExtracting full name (with changes)