Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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