Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Regex_replace help

afv2688
15 - Aurora
15 - Aurora

Hello @truct-kp,

 

If what you need is what you posted on the first message and looking at your data provided why don't you use just a Left(CVRG_ARRAY_TX, 11) ?

 

Just wondering.

 

Just in case also added a possible solution? Just in case "~" was the delimeter

 

Regards

truct-kp
6 - Meteoroid

~Dxxxxxx^D is not necessary last to left.

 

afv2688
15 - Aurora
15 - Aurora

Hello @truct-kp,

 

How about this:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

truct-kp
6 - Meteoroid

having problem nested LEFT() and right() function within regex_replace.  Can you repack and send me the workflow.

 

Labels