Subdomain Removal Countifs

English
,
#1

Hi,

So I have a question regarding URLs in Libreoffice Calc.
I am a big data collector for the company that I work for and I regularly get URLs that are subdomains of domains as for example http://cursus.verzamelgids.nl/

Is there a way I can let the Formula to count how many times a certain word is used ignore the subdomain (‘cursus’ in this case) and focus on ‘verzamelgids.nl’ instead? I am using the countifs function with this.

Is this even possible or?

Would love to hear from you all.

James

#2

Don’t work http://www.verzamelgids.nl/ ?

#3

That doesn’t work, I just tried it. Thank you for the suggestion though. It’s the whole URL inside of a cell.

#4

Please edit your question and explain in detail how you have formulated, with subdomains.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.