REPLACEREGEX([Text Field], ".*?_.*?_(.*?)_.*", "$1",true)
REPLACEREGEX
function says to replace string values in a given field (first parameter of the function) by looking for a specific pattern (known as regular expression), if it is not found then we mark the record in the column as empty (see last parameter of the function). The REPLACEREGEX (as opposed to SEARCHREGEX) function is used when you want to re-write the input text string as a formula result..*?
: Has any number of characters (0 or more, excluding new lines, but may include spaces)._
: Followed by an underscore..*?
: Followed by any characters (0 or more, excluding new lines, but may include spaces)._
:Followed by an underscore._
: Followed by an underscore..*?
: Followed by any number of characters (0 or more, excluding new lines, but may include spaces).It looks like you're new here. If you want to get involved, click one of these buttons!