The Extract text from column step extracts a portion of text based on a matching character or offset. You may use this to pull out company names from emails, remove part of an ID, or extract the timezone from any date/time stamp.

Extract text from column

Input/output

In this case, we're looking to extract email domains from our customer email addresses. Our input data has three columns: "first name", "last name", and "email".



After using the Extract text from column step, it gives us a new column named "domain names" where extracted email domains are listed (taken from the "email" column's values). This new column is filled with domain names.



Settings

First, specify the column that you'd like to extract text from.

Then, give your new column a name. This step will always create a new column with your extracted data.

Next, select an Operation. The options are:

find all text after
offset after
find all text before
offset before
offset after from the the end of text
offset before from the end of text

Was this article helpful?
Cancel
Thank you!