community
cancel
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

Asteroid

Hi,

 

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?


Cheers,

Asteroid

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

Timekeeper SaaS

Iseries eneterprise

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@nick22 

 

This should work:

 

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

 

Cheers,

Labels