Parse out Unique Identifier number out of URL?

[moemaus]

Hi,

I urgently need help!

What method or combination of methods would I have to use to parse the eight digit unique identifier out of an URL?

For example for the bold identifier below:

http://www.fitnessfactory.com?csrc=PPCADW-factory&ldd={ifsearch:s}{ifcontent:c}Q4nP8ZLc|pcrid|{creative}


Thank you!

 

[RonB1111]

If it's always followed by the 1st "|" symbol, use this formula assuming the URL is in cell A1:

=MID(A1,FIND("|",A1)-8,8)

If it isn't always followed by the 1st "|" symbol, please post some more sample data so we can try to identify a pattern.

 

[moemaus]

If it's always followed by the 1st "|" symbol, use this formula assuming the URL is in cell A1:

=MID(A1,FIND("|",A1)-8,8)

If it isn't always followed by the 1st "|" symbol, please post some more sample data so we can try to identify a pattern.

Thanks for the quick Answer!

It is always followed by "|", but when I type in the formula (adjusted the the respective cell) there appears a failure message "the formula you typed in contains an error."

What exactly does the -8 and 8 stand for? Maybe the mistake is connected to this.

 

[RonB1111]

Make sure you changed both instances of A1 to the cell that contains your.
It works for me with your url copied into A1.

The "Find" portion determines that the 1st "|" symbol is the 88th character in your string. I'm subtracting 8 from that so in the Mid formula it will start in the 80th position which is where your 8 digit unique identifier begins. The 8 says to return 8 characters.
Here's a link with further explanation:
Using Excel's Find and Mid to extract a substring when you don't know the start point - TechRepublic

If you still can't get it to work, please upload a copy of your excel file to a file sharing service and post the link to open it back here on this thread. (please make sure to set the security on the file so anyone with the link can download it, and don't upload any confidential or proprietary data).