Extract data from a string ?

[Maverick27]

Hi

Anyone care to share the Excel Function to extract data from a string ?

The logic to be used for formulating the Function is the extract the data string from the Right upto the 1st " / "

Example #1

https://oshwal-impresscreations-co-ke.stackstaging.com/wp-content/uploads/BIMAL/BIM0083-Alu-Frying-Pan-BFP205.jpg

Output

BIM0083-Alu-Frying-Pan-BFP205.jpg

Example #2

https://oshwal-impresscreations-co-ke.stackstaging.com/wp-content/uploads/GRUNWERG/CHW0066-Spare-Glass-Beaker-250Cc-22005R.jpg

Output

CHW0066-Spare-Glass-Beaker-250Cc-22005R.jpg

Thanks in Advance.

 

[James006]

Hi,
With your string in cell A1, you can test following

=RIGHT(A1,LEN(A1)-FIND("@",SUBSTITUTE(A1,CHAR(47),"@",(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(47),"")))/LEN(CHAR(47)))))

 

[arthurbr]

Power Query solution
let
Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByEachDelimiter({"/"}, QuoteStyle.Csv, true), {"Column1.1", "Column1.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type text}, {"Column1.2", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Column1.1"})
in
#"Removed Columns"

 

[Peter_SSs]

Another possibility

23 03 11.xlsm
	A	B
1	https://oshwal-impresscreations-co-...loads/BIMAL/BIM0083-Alu-Frying-Pan-BFP205.jpg	BIM0083-Alu-Frying-Pan-BFP205.jpg
2	https://oshwal-impresscreations-co-...G/CHW0066-Spare-Glass-Beaker-250Cc-22005R.jpg	CHW0066-Spare-Glass-Beaker-250Cc-22005R.jpg
Extract Last

Cell Formulas
Range	Formula
B1:B2	B1	=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",LEN(A1))),LEN(A1)))