Extract
Abstract
Extract text from value using regular expression.
Extract text from value using regular expression.
To extract digits, use
(\d+).To extract all of the text, use
(.*).To extract everything before a comma, use
(.*),(.*).To extract email domain, use
(?<=@)[^.]+(?=\.).
With the Output column(s) option, you can add new columns or replace an existing column in your data set. The columns append to your data set, with the naming convention of (column)_extracted, for example: Monthly Sales_extracted.
When to use this tool
Use when you want to extract text in specific ways using regular expressions.
You can also use the text part tool to extract text.