I have a text message provider that I use to send text messages to all my customers. If needed I can export a csv file containing specific data about the text messages. I'm interested in tow things from this sheet - one is provided for me - the date of the text message. The other is the sender. This illudes me however as the original value is based on whatever my customer desires. The text message itself however contains the subdomain AND the domain from my customer. This is the value I need (i.e. http//:subdomain.domain).
The only issue is, that this subdomain.domain is placed in different places in the text message, so I can't rely on the usal MID, SEARCH, FIND functions in excel. Sometimes http://
appears 23 characters in, sometimes 59. It varies.
Is there any way to make a generic formula that catches the subdomain.domain, that comes after http://
and is followed by .dk?
I've attached and embedded a sample of the csv file (domains and subdomains removed of course.Experts_exchange_data.xlsx