How do I pull the ASIN code from an Amazon url in Excel?
Variable length URL's, example:
Want to derive the cell result : B00BQ59SYM
from this
But could also be from this URL to the same location:
How do I pull the ASIN code from an Amazon url in Excel?
Variable length URL's, example:
Want to derive the cell result : B00BQ59SYM
from this
But could also be from this URL to the same location:
Slightly unrelated - but if you are doing Google Spreadsheet this can be done using
=REGEXEXTRACT(A1, "/([a-zA-Z0-9]{10})(?:[/?]|$)")
I am sure similar regex may work in Excel too.
For Google Sheets I have tested the code It works with ";" instead ","
so
=REGEXEXTRACT(A1;"/([a-zA-Z0-9]{10})(?:[/?]|$)")
;
is used in locales where comma is used for radix point like most European languages. It's unrelated to Google sheet
/dp/
and up to either a/
, a?
, or the end of the URL.