Parsing a specific string out of a URL

[Jmango3331]

Hi Everyone,

I'm try to parse out an 8 digit code from URLs that look like this:

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

The code I'm trying to parse out is in red and starts after {ifcontent:c} and then ends before the | character. I know that I can use a combination of the "mid" and "search" functions, but I keep getting errors.

Any suggestions would be greatly appreciated!

Thanks,
Jessica

[abubaniyan]

=MID(A1,FIND("{ifcontent:c}",A1,1)+13,FIND("|",A1,1)-(FIND("{ifcontent:c}",A1,1)+13))

TRY THIS....!

[oeldere]

this macro will do that for you

Please Login or Register  to view this content.

[ConneXionLost]

Another way:

Please Login or Register  to view this content.

[Jmango3331]

This worked!!! Thank you so much Abdul!