netsuite Exploiting formula columns in saved searches Parsing a hierarchical record name using a regular expression
Example
Using a regular expression, parse a record name that might be hierarchical. The expression looks for the final colon in the name. It returns what follows the colon, or the entire name if none:
regexp_substr( {name} , '[^:]*$' )
