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