Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Parsing columns using Regex

jay_viz
7 - Meteor

I have a workflow that extract AirBnb data from URLs and find out if certain features are offered in a listing. For example I am looking to see if a listing offers WiFi (Case Insensitive) or Dedicated Workspace or Long Term Stay Allowed. Final data appears as below, counting them as 1 or 0 based if these features are offered for a listing. 

 

I got first few things working, and I am stuck where how I could parse specific features and put 1 and 0 against them in the output. I have attached workflow I am using.

 

IDURLWiFiLong Term StayDedicated workspace
16910794https://www.airbnb.com/rooms/16910794100
12654250https://www.airbnb.com/rooms/12654250101

 

Thank you for the help

2 REPLIES 2
Raj
16 - Nebula

Hi,

Please find the solution for reference, Hope this helps

 

jay_viz
7 - Meteor

@Raj Thanks, what I was hoping to get is how can we extract the features I am interested in from the Regex. If you see 2nd Regex it randomly pick 3 columns in the output. I was trying to get a method to look for the features we care about as an output from there.

Labels
Top Solution Authors