Extract a word text separately in column by regex tool in alteryx

We will learn how to extract a Word text separately in a column by using the RegEx tool in Alteryx in this recipe

Recipe Objective: How to Extract a word (text) separately in the column by RegEx tool in Alteryx?

Step 1:

Open Alteryx Designer software. Here New workflow1 is by default available.

Step 2:

Now go to the Favorite tab or IN/OUT tab, where we can see a tool named "INPUT DATA."

Step 3:

Drag the INPUT DATA tool on the below side in the New Workflow1. Now go to the Configuration pane/window and click on the drop-down available to connect a file or database.

Step 4:

After this, it will redirect us to the data connection window, here we have to click on the files option, then click on the select file option, and ask us to select a file from the folder. Here we have chosen a file named "Coffee Chain Sales." Then select "Sheet2" from the file and click on Ok.

Step 5:

Then click on the Run button or press CTRL+R. In the results workflow, data will be displayed. Then drag the RegEx tool from the Parse tab and connect it with the INPUT DATA tool in the New workflow.

Step 6:

Connect the Input data tool to the input anchor of the RegEx tool. Then go to the configuration pane/window, select the option "Product" from Column to Parse, and then type "([A-Z]+)" in the Regular Expression tab, select case insensitive. Now in the Output method, choose option "Parse."Now click on the Run button to view the results workflow with text or word shown in separate fields/columns.

What Users are saying..

profile image

Ray han

Tech Leader | Stanford / Yale University
linkedin profile url

I think that they are fantastic. I attended Yale and Stanford and have worked at Honeywell,Oracle, and Arthur Andersen(Accenture) in the US. I have taken Big Data and Hadoop,NoSQL, Spark, Hadoop... Read More

Relevant Projects

Learn Hyperparameter Tuning for Neural Networks with PyTorch
In this Deep Learning Project, you will learn how to optimally tune the hyperparameters (learning rate, epochs, dropout, early stopping) of a neural network model in PyTorch to improve model performance.

Build a Text Generator Model using Amazon SageMaker
In this Deep Learning Project, you will train a Text Generator Model on Amazon Reviews Dataset using LSTM Algorithm in PyTorch and deploy it on Amazon SageMaker.

Customer Churn Prediction Analysis using Ensemble Techniques
In this machine learning churn project, we implement a churn prediction model in python using ensemble techniques.

Natural language processing Chatbot application using NLTK for text classification
In this NLP AI application, we build the core conversational engine for a chatbot. We use the popular NLTK text classification library to achieve this.

Build an Image Segmentation Model using Amazon SageMaker
In this Machine Learning Project, you will learn to implement the UNet Architecture and build an Image Segmentation Model using Amazon SageMaker

Learn How to Build a Logistic Regression Model in PyTorch
In this Machine Learning Project, you will learn how to build a simple logistic regression model in PyTorch for customer churn prediction.

Build CNN for Image Colorization using Deep Transfer Learning
Image Processing Project -Train a model for colorization to make grayscale images colorful using convolutional autoencoders.

Predict Churn for a Telecom company using Logistic Regression
Machine Learning Project in R- Predict the customer churn of telecom sector and find out the key drivers that lead to churn. Learn how the logistic regression model using R can be used to identify the customer churn in telecom dataset.

PyCaret Project to Build and Deploy an ML App using Streamlit
In this PyCaret Project, you will build a customer segmentation model with PyCaret and deploy the machine learning application using Streamlit.

AWS MLOps Project for Gaussian Process Time Series Modeling
MLOps Project to Build and Deploy a Gaussian Process Time Series Model in Python on AWS