Parsing columns using Regex

Question

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 workspace16910794https://www.airbnb.com/rooms/1691079410012654250https://www.airbnb.com/rooms/12654250101

Thank you for the help

Regex Wf.yxmd

jay_viz · Answer

@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.

Raj · Answer

Hi,

Please find the solution for reference, Hope this helps

Regex Wf.yxmd