Help with parsing URL link using left and find functions

[RKROX907]

Hi Everyone,

Cell A1 has this text:

https://somewebsite/images/products/SkuName/genricFileName.jpg

I would like to extract SkuName

The SkuName always will come after the 5th "/" and will end by the 6th "/"

the end result should be, B1 has the text: SkuName

Please help
Thanks!

 

[sandy666]

if it is a representative example you can try PowerQuery (Get&Transform)

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]url[/td][td][/td][td=bgcolor:#70AD47]url[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]https://somewebsite/images/products/SkuName/genricFileName.jpg[/td][td][/td][td=bgcolor:#E2EFDA]SkuName[/td][/tr]
[/table]

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Extracted Text Between Delimiters" = Table.TransformColumns(Source, {{"url", each Text.BetweenDelimiters(_, "/", "/", {1, RelativePosition.FromEnd}, 0), type text}})
in
    #"Extracted Text Between Delimiters"[/SIZE]

 

[DanteAmor]

Try with this formula

<b>Sheet</b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:491px;" /><col style="width:120px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >https://somewebsite/images/products/SkuName/genricFileName.jpg</td><td >SkuName</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b> </b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"/","#",5),"/","#",5),"#",REPT(" ",99)),99,99))</td></tr></table></td></tr></table> <br /><br />

 

[jtakw]

Hi,

How about this:

Book1
	A	B
1	https://somewebsite/images/products/SkuName/genricFileName.jpg	SkuName
Sheet647

Cell Formulas
Range	Formula
B1	=TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",255)),255*5,255))

 

[RKROX907]

Thank you jtakw, sandy666 & DanteAmor

 

[DanteAmor]

You're welcome and thanks for the feedback.

 

[jtakw]

You're welcome, thanks for the feedback.