We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regular expression

tutankamon
7 - Meteor

Hi everyone! 

 

I am having a lot of trouble with regular expressions and don't find the right one. I have a .html file with lots of data and many web pages written on it. I would need a regular expression that selects a web page with the following pattern:

- starts with "https:"

-finishes with ".com"

-"google" does not show up in the web page

 

Thank you very much in advance!

1 REPLY 1
SamDesk
11 - Bolide

Hi @tutankamon,

 

 

^(?!.*google)https:.+\.com$

This should work for you, it matches anything starting with "https:" and ends in ".com" with "google" being nowhere in the string.

 

 

https://regexr.comMatch
https://regexr.com\No match
https://google.com\No match
https://www.google.com  No match

 

Sam :)

Labels
Top Solution Authors