ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community has implemented a new single sign-on experience. If you are having issues with your account, please review the FAQ's.

Alteryx Designer Discussions

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

Regex_replace help

afv2688
16 - Nebula
16 - Nebula

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
16 - Nebula
16 - Nebula

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