Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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