Alteryx designer Discussions

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

Regex_replace help

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
6 - Meteoroid

~Dxxxxxx^D is not necessary last to left.

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
6 - Meteoroid

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

 

Labels