Hi Guys,
I basically have a list of URLs some of them are page URLs e.g. http://shop.davidjones.com.au/djs/en/davidjones/dresses
And some are domains http://www.christinarossi.com/
What i want to basically do is remove all domain names from the list.
I've attached a sample.
Any ideas if you can do this easily with excel?
Thanks,
Chris
What would a sample answer look like?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
All the domain names would be removed e.g.:
http://lisagowing.com/
So anything which has nothing after the third /
In B2 and copy down,
=(RIGHT(A2) = "/") * (LEN(A2) - LEN(SUBSTITUTE(A2, "/", "")) = 3)
Autofilter on col B and clear or delete the rows with a 1.
Row\Col http://www.myer.com.au/shop/mystore/designer-dresses http://shop.davidjones.com.au/djs/en/davidjones/designer-dresses http://shop.davidjones.com.au/djs/en/davidjones/dresses https://www.shopbop.com/clothing-dresses/br/v=1/2534374302063518.htm?all http://www.frockaholics.com/ http://www.talulah.com.au/shop/talulah http://www.review-australia.com/shop/dresses http://www.asos.com/au/Women/Womens-Designer/Dresses/Cat/pgecategory.aspx?cid=6932 http://www.bariano.com.au/estore/category/dresses.aspx http://www.tadashishoji.com/shop/dresses http://www.stevenalan.com/womens-clothing-dresses http://www.talulah.com.au/shop/talulah-swim-resort/resort-dresses-and-kimonos http://www.boutique1.com/womens/clothing/dresses http://www.christinarossi.com/ http://www.tkmaxx.com/women/dresses/icat/3091
Last edited by shg; 09-08-2015 at 08:39 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks