Cookie Consent by Free Privacy Policy Generator

Google Sheets Regex for excluding subfolders

If you have a website that have multiple international territories hosted in subfolder. Use the formula below to exclude the subfolders. This will give you cleaner data to isolate and sort. An example usage URL remapping for migrations.

custom.PNG


Code:
=not(regexmatch(A:A, "(?i)/au/|/ca/|/ie/|/de/|/ie/|/es/|/it/|/fr/|/nz/"))
 
Last edited:
Back
Top