In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

multiple regex?

utsarunner981
8 - Asteroid

can there be more than one regex function within the same workflow? 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @utsarunner981 

 

Surely definitely. What usecase do you have in your mind ? we can help you out in getting an idea of how to solve 🙂

utsarunner981
8 - Asteroid

Hi @atcodedog05 

I have a regex in the workflow but i would like to add another with different parameters. 

 

for example: 

my data

column A

ABCDEFGHIJKL

 

my output 

(delete first 8 characters) IJKL

atcodedog05
22 - Nova
22 - Nova

Hi @utsarunner981 

 

You can write a regex formula like this

 

REGEX_Replace([Field1], "^.{8}", "")

 

Replace starts 8 chars with blank

 

Workflow:

atcodedog05_0-1629477692581.png

 

Hope this helps : )

 

utsarunner981
8 - Asteroid

Thank you @atcodedog05 , this solution works!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @utsarunner981 

 

If there is anything else i can help you with let me know.

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels
Top Solution Authors