Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Converting the following python regex functions into Regex_Match in Alteryx

Siddhantt_1999
5 - Atom
  • r"([^a-zA-Z0-9])(" + token + r")([^a-zA-Z0-9])"
  • r"([^a-zA-Z0-9])(" + token + r")($)"
  • r"(^)(" + token + r")([^a-zA-Z0-9])"
  • r"(^)(" + token + r")($)"

I have the above 4 regex functions built in Python, I want to convert these into regex_match in Alteryx to search for the word from column 'Token" in a column called "Description" and return True if the word is found. Can someone please help convert these Regex functions into 4 separate regex_match functions in Alteryx? I tried doing it but the response was always coming as false for all 4 functions, not sure where I am going wrong.

 

Also, I made these 4 cases instead of directly using "Contains" as there are edge cases to handle which these functions do in python but now I need these in Alteryx without using the python tool.

 

2 REPLIES 2
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

Can you show an example of what you want mean in www.regex101.com then screenshot and put here. You'll get an answer really quick that way.

 

either share the link via save and share options which can be found in the top-left of the browser: https://regex101.com/r/ZHMcLZ/1 

 

or just send a picture of lines you want to match and lines you don't:

Screenshot community4.png


All the best,

BS

All the best,
BS

LinkedIN

Bulien
caltang
17 - Castor
17 - Castor

Second what Ben @BS_THE_ANALYST says. Directly converting a REGEX pattern like that may not be the best way to tackle your problem. Maybe provide some sample data and then we can help convert it for you better.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels