topic Re: Regex for Contact has viewed at least one URL that matches regular expression in Tips, Tricks & Best Practices

Regex for Contact has viewed at least one URL that matches regular expression

helenechoo — Mon, 09 Nov 2020 15:33:53 GMT

Hi,

I'm trying to create a regex that matches:

https://www.youweagency.com/staffing

youweagency.com/staffing

youweagency.nl/staffing

youweagency.se/staffing

https://www.youweagency.com/e-commerce

youweagency.nl/e-commerce

where staffing or e-commerce can also be hosting or strategy-organization etc. (we have 8 of those in total),

but does not match:

https://www.youweagency.com/e-commerce/e-commerce-and-pim-one-integrated-suite

youweagency.nl/e-commerce/e-commerce-and-pim-one-integrated-suite

so anything after e-commerce (or any of the other 7) shouldn't match.

I've been trying this:

which I tested with https://www.regextester.com/ and worked fine.

I can't get it to work here in Hubspot though.

Could you please help?

Thanks in advance!

Re: Regex for Contact has viewed at least one URL that matches regular expression

natsumimori — Tue, 10 Nov 2020 02:44:39 GMT

Hi @helenechoo ,

Thanks for reaching out to the HubSpot Community. I'm not too familiar with this topic, but let's see if Community member can share some thoughs!

@tjoyce , is this topic something you can share advice?

Re: Regex for Contact has viewed at least one URL that matches regular expression

tjoyce — Tue, 10 Nov 2020 09:17:33 GMT

I am going to tag @John - I have seen him write some beautiful regex's and hopefully he has an answer for you @helenechoo

Re: Regex for Contact has viewed at least one URL that matches regular expression

John — Tue, 10 Nov 2020 14:18:20 GMT

Thanks @tjoyce. @helenechoo, here are some questions for you to answer before any of us can help: Is this a text field, url field, or link field? Are you developing locally or in the hs IDE?

Re: Regex for Contact has viewed at least one URL that matches regular expression

helenechoo — Tue, 10 Nov 2020 14:23:31 GMT

Hi @John,

Thanks for reacting!

This is in the contact property Hubspot score:

Sorry, not a developer so not sure whether this answers your question!

Let me know if you need any more information.

Best,

Helene

Re: Regex for Contact has viewed at least one URL that matches regular expression

John — Tue, 10 Nov 2020 16:31:48 GMT

You need to make the https:// and www. strings optional

The ? makes anything preceeding it optional. Please note, I did not test this in hubspot.

Edit: if you want to account for query strings and tracking codes, then you could remove the $ at the end of the regex above and add the following code to the end: (?:\?.*)?

Re: Regex for Contact has viewed at least one URL that matches regular expression

helenechoo — Wed, 11 Nov 2020 06:44:27 GMT

That worked, thanks!

Re: Regex for Contact has viewed at least one URL that matches regular expression

natsumimori — Wed, 11 Nov 2020 07:10:33 GMT

Thank you @tjoyce for tagging in @John !