Dear Excel Wizards,
I am stumped with this problem. I have a Excel file with URLs. I want to extract one part of the URL, the only problem is the text I want to extract changes a bit. It will always start with "id=", however after that it can have 4, 5 or 6 numbers following. E.g
id=1234
id=12345
id=123456
The output I am looking for is the "id=12345" pasted into another call. Note: the string "12345" is just an example. Real output will be all numeric but not in such a neat order.
So far I have tried to count and take the data from the 10th "/" where this the text field of 'id=' usually lives. I say usually because counting slashes I found the vast majority of my 'id=' I am looking for are between the 10th and 11th "/" but some are between the 8th and 9th "/".
I have also tried
=MID(A8,FIND("id=",A1),MATCH(FALSE,INDEX(CODE(MID(A8,ROW(INDIRECT(FIND("id=",A8)+2 & ":" & LEN(A8))),1))<65,0),0))
to no success.
I would appreciate any help you can lend. Please see the attached sample .xlsx for examples of the URL.
Thanks again,
Tim
Bookmarks