Extracting a SKU from a URL

[laurigardner]

Hi,

I have the following example URLs:
https://viyet.com/andrianna-shamaris-teak-and-bone-inlay-circular-bookcase-sto-49740-27277.html
https://viyet.com/janus-et-cie-large-shell-bowl-acc-49959-2600.html
https://viyet.com/jonathan-adler-danner-loveseat-sea-45150-33425.html

The length is variable from the left, but from the right it isn't.



What I need to do is extract from the 3rd "-" with a trim of .html So it looks like this:
sto-49740-27277
acc-49959-2600
sea-45150-33425

I keep trying to figure out how to do this with MID, RIGHT and SEARCH, but it's not coming together.

Any help would be greatly appreciated!

 

[laurigardner]

Apologies. I can't seem to edit the original message, and I hadn't noticed that it trunkates the links. Here's the links as text:

https://viyet.com/andrianna-shamaris-teak-and-bone-inlay-circular-bookcase-sto-49740-27277.html
https://viyet.com/janus-et-cie-large-shell-bowl-acc-49959-2600.html
https://viyet.com/jonathan-adler-danner-loveseat-sea-45150-33425.html

 

[jtakw]

Hi,

Assuming your data starts at A1 down, formula in B1 copied down:

Book1
	A	B
1	https://viyet.com/andrianna-shamaris-teak-and-bone-inlay-circular-bookcase-sto-49740-27277.html	sto-49740-27277
2	https://viyet.com/janus-et-cie-large-shell-bowl-acc-49959-2600.html	acc-49959-2600
3	https://viyet.com/jonathan-adler-danner-loveseat-sea-45150-33425.html	sea-45150-33425
Sheet324

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",100)),300))," ","-"),".html","")

 

[Peter_SSs]

This is probably too risky to rely on but it does work for the samples given.

Excel Workbook
	A	B
1	https://viyet.com/andrianna-shamaris-teak-and-bone-inlay-circular-bookcase-sto-49740-27277.html	sto-49740-27277
2	https://viyet.com/janus-et-cie-large-shell-bowl-acc-49959-2600.html	acc-49959-2600
3	https://viyet.com/jonathan-adler-danner-loveseat-sea-45150-33425.html	sea-45150-33425
Extract