Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Using Regex to give me everything Except specified value




I'm Using the Regex Replace function in my formula tool to pull out the Version of the Product, I now need to revers the function and just give me the Product name.


My function is as follows:


REGEX_Replace([Item Description], "^.* (V\d+(\.\d+)?).*", "$1")


Can I just change the syntax abit and have output what I need or does a new function need to be written?


Thank you


Alteryx Certified Partner
Alteryx Certified Partner

Hi @nick22 


Could you give a sample of how your records look like and what kind of Products you want to extract from them?



Hi @Thableaus 


Sure so currently I have things like 


Timekeeper V8

Timekeeper V8.1 SaaS

ISeries V8 enterprise


and that function pulls the V8.1 or V8 or if it is a different version like 7 or 6 then V7 or V6


But I need to just output 



Timekeeper SaaS

Iseries eneterprise

Alteryx Certified Partner
Alteryx Certified Partner



This should work:


REGEX_Replace([Item Description], "^(.*)\s(?:V\d+(\.\d+)?)(.*)", "$1$3")