ScottHunterQrew Member1 year 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 Legend1 year agoThis tests OK for me.NotRight(NotRight(NotRight([My Underscored String],"_"),"_"),"_")
Related ContentExtract Text Between 2 special charactersExtract Date and Comment from prepend log entry fieldHow To Extract All Info from a Form into CSV File?Extracting multiple substrings from a text stringExport everything from our App