Extract strings from URLs

%3CLINGO-SUB%20id%3D%22lingo-sub-1967835%22%20slang%3D%22en-US%22%3EExtract%20strings%20from%20URLs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1967835%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20please%2C%20I%20need%20a%20formula%20%2F%20script%20to%20extract%20product%20names%20(and%20sometimes%20the%20product%20numbers)%20from%20the%20following%20URLs.%20They%20are%20different%20eshops%2C%20so%20I%20separate%20them%20with%20lines.%20First%20I%20enter%20what%20I%20need%20to%20extract%20and%20the%20addresses%20below.%26nbsp%3BI%20have%20thousands%20of%20addresses%20so%20if%20it%20could%20do%20something%20automatically%2C%20it%20would%20help%20me%20a%20lot.%20Thanks%20for%20help!%3C%2FP%3E%3CP%3E%3CSTRONG%3E1)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Enames%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Erock-serving-board-round%3CBR%20%2F%3Ebrew-tray-brwtr01%3CBR%20%2F%3Estone-serve-board-stcb02%3CBR%20%2F%3Ebrew-cafetiere-stainless-steel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EURLs%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fcatalog%2Fproduct%2Fview%2Fid%2F4734%2Fs%2Frock-serving-board-round%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fcatalog%2Fproduct%2Fview%2Fid%2F4734%2Fs%2Frock-serving-board-round%2F%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fcatalog%2Fproduct%2Fview%2Fid%2F18%2Fs%2Fbrew-tray-brwtr01%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fcatalog%2Fproduct%2Fview%2Fid%2F18%2Fs%2Fbrew-tray-brwtr01%2F%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fcatalog%2Fproduct%2Fview%2Fid%2F138%2Fs%2Fstone-serve-board-stcb02%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fcatalog%2Fproduct%2Fview%2Fid%2F138%2Fs%2Fstone-serve-board-stcb02%2F%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fbrew-cafetiere-stainless-steel.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.tomdixon.net%2Fen_us%2Fbrew-cafetiere-stainless-steel.html%3C%2FA%3E%3C%2FP%3E%3CP%3E____________________________%3C%2FP%3E%3CP%3E%3CSTRONG%3E2)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Enames%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eberlin-door-set-with-globe-knob-deadbolt-satin-nickel%3CBR%20%2F%3Eorbit-12-chandelier%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EURLs%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.pntrs.com%2Ft%2F1-9020-217793-9020%3Fwebsite%3D324209%26amp%3Burl%3Dhttps%253A%252F%252Fschoolhouseelectric.myshopify.com%252Fproducts%252Fberlin-door-set-with-globe-knob-deadbolt-satin-nickel%253Fdfw_tracker%253D34341-29667693592620%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.pntrs.com%2Ft%2F1-9020-217793-9020%3Fwebsite%3D324209%26amp%3Burl%3Dhttps%253A%252F%252Fschoolhouseelectric.myshopify.com%252Fproducts%252Fberlin-door-set-with-globe-knob-deadbolt-satin-nickel%253Fdfw_tracker%253D34341-29667693592620%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.pjatr.com%2Ft%2F1-9020-217793-9020%3Fwebsite%3D324209%26amp%3Burl%3Dhttps%253A%252F%252Fschoolhouseelectric.myshopify.com%252Fproducts%252Forbit-12-chandelier%253Fdfw_tracker%253D34341-32070473285676%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.pjatr.com%2Ft%2F1-9020-217793-9020%3Fwebsite%3D324209%26amp%3Burl%3Dhttps%253A%252F%252Fschoolhouseelectric.myshopify.com%252Fproducts%252Forbit-12-chandelier%253Fdfw_tracker%253D34341-32070473285676%3C%2FA%3E%3C%2FP%3E%3CP%3E____________________________%3C%2FP%3E%3CP%3E%3CSTRONG%3E3)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Enames%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Earro-22-cordura-backpack%3CBR%20%2F%3Eebury-full-grain-leather-and-walnut-tech-tidy%3CBR%20%2F%3E6-moncler-1017-alyx-9sm-black-2cm-webbing-belt%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EURLs%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fprf.hn%2Fclick%2Fcamref%3A1100l9Jhy%2Fcreativeref%3A1101l32565%2Fdestination%3Ahttps%3A%2F%2Fwww.mrporter.com%2Fen-us%2Fmens%2Fproduct%2Farcteryx%2Fsport%2Foutdoor-accessories%2Farro-22-cordura-backpack%2F5983760398543167%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fprf.hn%2Fclick%2Fcamref%3A1100l9Jhy%2Fcreativeref%3A1101l32565%2Fdestination%3Ahttps%3A%2F%2Fwww.mrporter.com%2Fen-us%2Fmens%2Fproduct%2Farcteryx%2Fsport%2Foutdoor-accessories%2Farro-22-cordura-backpack%2F5983760398543167%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fprf.hn%2Fclick%2Fcamref%3A1100l9Jhy%2Fcreativeref%3A1101l32565%2Fdestination%3Ahttps%3A%2F%2Fwww.mrporter.com%2Fen-us%2Fmens%2Fproduct%2Flinley%2Flifestyle%2Ftech-accessories%2Febury-full-grain-leather-and-walnut-tech-tidy%2F3983529958961062%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fprf.hn%2Fclick%2Fcamref%3A1100l9Jhy%2Fcreativeref%3A1101l32565%2Fdestination%3Ahttps%3A%2F%2Fwww.mrporter.com%2Fen-us%2Fmens%2Fproduct%2Flinley%2Flifestyle%2Ftech-accessories%2Febury-full-grain-leather-and-walnut-tech-tidy%2F3983529958961062%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fprf.hn%2Fclick%2Fcamref%3A1100l9Jhy%2Fcreativeref%3A1101l32565%2Fdestination%3Ahttps%3A%2F%2Fwww.mrporter.com%2Fen-us%2Fmens%2Fproduct%2Fmoncler-genius%2Faccessories%2Ffabric-belts%2F6-moncler-1017-alyx-9sm-black-2cm-webbing-belt%2F14097096497347963%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fprf.hn%2Fclick%2Fcamref%3A1100l9Jhy%2Fcreativeref%3A1101l32565%2Fdestination%3Ahttps%3A%2F%2Fwww.mrporter.com%2Fen-us%2Fmens%2Fproduct%2Fmoncler-genius%2Faccessories%2Ffabric-belts%2F6-moncler-1017-alyx-9sm-black-2cm-webbing-belt%2F14097096497347963%3C%2FA%3E%3C%2FP%3E%3CP%3E____________________________%3C%2FP%3E%3CP%3E%3CSTRONG%3E4)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Enames%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Edemetra-led-wall-sconce-by-artemide-ATD1707974%3CBR%20%2F%3Etriaire-ceiling-fan-by-fanimation-fans-FNF1864828%3CBR%20%2F%3Epanton-chair-1999-by-vitra-R277434%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EURLs%3A%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Flumens.evyy.net%2Fc%2F2351837%2F786228%2F3281%3Fprodsku%3DATD1707974%26amp%3Bu%3Dhttps%253A%252F%252Fwww.lumens.com%252Fdemetra-led-wall-sconce-by-artemide-ATD1707974.html%26amp%3Bintsrc%3DCATF_5658%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Flumens.evyy.net%2Fc%2F2351837%2F786228%2F3281%3Fprodsku%3DATD1707974%26amp%3Bu%3Dhttps%253A%252F%252Fwww.lumens.com%252Fdemetra-led-wall-sconce-by-artemide-ATD1707974.html%26amp%3Bintsrc%3DCATF_5658%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flumens.evyy.net%2Fc%2F2351837%2F786228%2F3281%3Fprodsku%3DFNF1864828%26amp%3Bu%3Dhttps%253A%252F%252Fwww.lumens.com%252Ftriaire-ceiling-fan-by-fanimation-fans-FNF1864828.html%26amp%3Bintsrc%3DCATF_5658%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Flumens.evyy.net%2Fc%2F2351837%2F786228%2F3281%3Fprodsku%3DFNF1864828%26amp%3Bu%3Dhttps%253A%252F%252Fwww.lumens.com%252Ftriaire-ceiling-fan-by-fanimation-fans-FNF1864828.html%26amp%3Bintsrc%3DCATF_5658%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flumens.evyy.net%2Fc%2F2351837%2F786228%2F3281%3Fprodsku%3DR277434%26amp%3Bu%3Dhttps%253A%252F%252Fwww.lumens.com%252Fpanton-chair-1999-by-vitra-R277434.html%26amp%3Bintsrc%3DCATF_5658%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Flumens.evyy.net%2Fc%2F2351837%2F786228%2F3281%3Fprodsku%3DR277434%26amp%3Bu%3Dhttps%253A%252F%252Fwww.lumens.com%252Fpanton-chair-1999-by-vitra-R277434.html%26amp%3Bintsrc%3DCATF_5658%3C%2FA%3E%3C%2FP%3E%3CP%3E____________________________%3C%2FP%3E%3CP%3E%3CSTRONG%3E5)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Enames%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eeco-adjustable-base%253Fvariant%253D36850071011478%3CBR%20%2F%3Esuvin-organic-cotton-sheets%253Fvariant%253D36584417493142%3CBR%20%2F%3Eavocado-vegan-mattress%253Fvariant%253D36584404746390%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EURLs%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Favocadomattress.n5ka.net%2Fc%2F2351837%2F638621%2F10135%3Fprodsku%3DAVFECOBASE-40%26amp%3Bu%3Dhttps%253A%252F%252Fwww.avocadogreenmattress.com%252Fcollections%252Fbases%252Fproducts%252Feco-adjustable-base%253Fvariant%253D36850071011478%26amp%3Bintsrc%3DCATF_4850%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Favocadomattress.n5ka.net%2Fc%2F2351837%2F638621%2F10135%3Fprodsku%3DAVFECOBASE-40%26amp%3Bu%3Dhttps%253A%252F%252Fwww.avocadogreenmattress.com%252Fcollections%252Fbases%252Fproducts%252Feco-adjustable-base%253Fvariant%253D36850071011478%26amp%3Bintsrc%3DCATF_4850%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Favocadomattress.n5ka.net%2Fc%2F2351837%2F638621%2F10135%3Fprodsku%3DAVO600SUVNATL-70%26amp%3Bu%3Dhttps%253A%252F%252Fwww.avocadogreenmattress.com%252Fproducts%252Fsuvin-organic-cotton-sheets%253Fvariant%253D36584417493142%26amp%3Bintsrc%3DCATF_4850%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Favocadomattress.n5ka.net%2Fc%2F2351837%2F638621%2F10135%3Fprodsku%3DAVO600SUVNATL-70%26amp%3Bu%3Dhttps%253A%252F%252Fwww.avocadogreenmattress.com%252Fproducts%252Fsuvin-organic-cotton-sheets%253Fvariant%253D36584417493142%26amp%3Bintsrc%3DCATF_4850%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Favocadomattress.n5ka.net%2Fc%2F2351837%2F638621%2F10135%3Fprodsku%3DSFMAVAVSTTRG-70%26amp%3Bu%3Dhttps%253A%252F%252Fwww.avocadogreenmattress.com%252Fproducts%252Favocado-vegan-mattress%253Fvariant%253D36584404746390%26amp%3Bintsrc%3DCATF_4850%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Favocadomattress.n5ka.net%2Fc%2F2351837%2F638621%2F10135%3Fprodsku%3DSFMAVAVSTTRG-70%26amp%3Bu%3Dhttps%253A%252F%252Fwww.avocadogreenmattress.com%252Fproducts%252Favocado-vegan-mattress%253Fvariant%253D36584404746390%26amp%3Bintsrc%3DCATF_4850%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1967835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi, please, I need a formula / script to extract product names (and sometimes the product numbers) from the following URLs. They are different eshops, so I separate them with lines. First I enter what I need to extract and the addresses below. I have thousands of addresses so if it could do something automatically, it would help me a lot. Thanks for help!

1)

names:

rock-serving-board-round
brew-tray-brwtr01
stone-serve-board-stcb02
brew-cafetiere-stainless-steel

 

URLs:

https://www.tomdixon.net/en_us/catalog/product/view/id/4734/s/rock-serving-board-round/
https://www.tomdixon.net/en_us/catalog/product/view/id/18/s/brew-tray-brwtr01/
https://www.tomdixon.net/en_us/catalog/product/view/id/138/s/stone-serve-board-stcb02/
https://www.tomdixon.net/en_us/brew-cafetiere-stainless-steel.html

____________________________

2)

names:

berlin-door-set-with-globe-knob-deadbolt-satin-nickel
orbit-12-chandelier

 

URLs:

https://www.pntrs.com/t/1-9020-217793-9020?website=324209&url=https%3A%2F%2Fschoolhouseelectric.mysh...

 

https://www.pjatr.com/t/1-9020-217793-9020?website=324209&url=https%3A%2F%2Fschoolhouseelectric.mysh...

____________________________

3)

names:

arro-22-cordura-backpack
ebury-full-grain-leather-and-walnut-tech-tidy
6-moncler-1017-alyx-9sm-black-2cm-webbing-belt

 

URLs:
https://prf.hn/click/camref:1100l9Jhy/creativeref:1101l32565/destination:https://www.mrporter.com/en...

 

https://prf.hn/click/camref:1100l9Jhy/creativeref:1101l32565/destination:https://www.mrporter.com/en...

 

https://prf.hn/click/camref:1100l9Jhy/creativeref:1101l32565/destination:https://www.mrporter.com/en...

____________________________

4)

names:

demetra-led-wall-sconce-by-artemide-ATD1707974
triaire-ceiling-fan-by-fanimation-fans-FNF1864828
panton-chair-1999-by-vitra-R277434

 

URLs:
https://lumens.evyy.net/c/2351837/786228/3281?prodsku=ATD1707974&u=https%3A%2F%2Fwww.lumens.com%2Fde...

 

https://lumens.evyy.net/c/2351837/786228/3281?prodsku=FNF1864828&u=https%3A%2F%2Fwww.lumens.com%2Ftr...

 

https://lumens.evyy.net/c/2351837/786228/3281?prodsku=R277434&u=https%3A%2F%2Fwww.lumens.com%2Fpanto...

____________________________

5)

names:

eco-adjustable-base%3Fvariant%3D36850071011478
suvin-organic-cotton-sheets%3Fvariant%3D36584417493142
avocado-vegan-mattress%3Fvariant%3D36584404746390

 

URLs:

https://avocadomattress.n5ka.net/c/2351837/638621/10135?prodsku=AVFECOBASE-40&u=https%3A%2F%2Fwww.av...

 

https://avocadomattress.n5ka.net/c/2351837/638621/10135?prodsku=AVO600SUVNATL-70&u=https%3A%2F%2Fwww...

 

https://avocadomattress.n5ka.net/c/2351837/638621/10135?prodsku=SFMAVAVSTTRG-70&u=https%3A%2F%2Fwww....

0 Replies