Excel

Extract a substring between two characters or chain of characters

=MID(LEFT(E2; FIND("%26"; E2)-1); FIND("uid="; E2)+4; LEN(E2))

Extract a substring at the right of a character

=RIGHT(E2;LEN(E2)-FIND("/download";E2)+1)