Is there any function or way to search for text in a variable using regular expressions?
STATISTICA provides a broad selection of regular expression functions that can be used in spreadsheet formulas just as all other functions. Regular expressions provide the ability to search and replace text using “fuzzy” matching. The regular expression functions available within STATISTICA are RE_SEARCH, RE_MATCH, RE_REPLACE, and LIKE.