In Alteryx, we can use the regex tool to Parse, Match, Tokenize or Replace data.
Parse: Divide the expression into distinct columns, defining their names, types, and sizes based on the extracted content.
Match: Add a column indicating:
Trueif the expressions match the specified criteria.Falseif the expressions do not meet the defined conditions.
Replace: Substitute the identified expression with a different text or pattern within the dataset.
Tokenize: Split a column's content into segments using a regex function.
The table below summarizes several useful regex expressions frequently employed:
