This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Discussions

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

Regex_replace help

afv2688
Alteryx Certified Partner
Alteryx Certified Partner
‎02-14-2020 07:22 AM

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

regex.yxmd
Reply
0 Likes
truct-kp
6 - Meteoroid
‎02-14-2020 08:03 AM

~Dxxxxxx^D is not necessary last to left.

 

Reply
0 Likes
afv2688
Alteryx Certified Partner
Alteryx Certified Partner
‎02-14-2020 08:52 AM

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

Reply
0 Likes
truct-kp
6 - Meteoroid
‎02-14-2020 09:19 AM

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

 

Reply
0 Likes
Labels