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