Need to parse out a portion of a URL query string

[sbrien]

I have a few hundred URLs that include campaign ID strings within them. I need a way to separate out the specific IDs from each URL.

All of the campaign IDs are preceded by "?cid=" and they all follow a pattern of having seven sets of characters, each separated by a dash (e.g. xx-xxx-xxx-xx-xx-xxx-x). The problem is that the number of characters in each set is not consistent. Only the number of sets remains the same.

Is there a way to extract just the specific string of characters immediately following the "?cid=" that includes those six dashes?

Thanks,
Sbrien

 

[DeBeuz]

Hi Sbrien,

I can not think of a solution for this at the moment without using VBA (macro).
But do you have some examples of the full urls?
Is there always a specific string directly behing the seven sets, e.g. a comma, end of line or another question marked identifier?
If so, that would make life a lot easier.

Paul

 

[dotmannn]

Shouldn't be too difficult. Please provide an example set of URLs

 

[pgc01]

Hi

What comes after the six dashes data? How do we know, after the 6 dashes, that the data you want ended?