Google Spreadsheet Post #1543
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-21-2014
post by nellyshark (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/kAsQDvsymmk)
Google Spreadsheet Split Function
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-21-2014
post by nellyshark (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/kAsQDvsymmk)
Google Spreadsheet Split Function
Hi All,
Not really too sure how to do this how do I have a series of URLs in Column A and split that string up to include only the second last part of the string (if it exists). The URL length may be different.
For examples I have a spreadsheet. In Column A there are a series of URLs e.g
https://www.example.com/a/b/c/ d/e/f.html Value I want captured = e
https://www.example.com/a/b. html Value I want captured = a
https://www.example.com/a/b/c/ d.html Value I want captured = c
https://www.example.com/a.html Value I want captured = www.example.com
https://www.example.com/ Value I want captured = " "
I have tried doing various regex but it's way above me. Have also tried split function but that splits everything
Basically what I want is a spreadsheet where I can input a list of URLs in Column A and then pull a child and parent hierarchy in Column B & Column C (the page f.html being a child or e, the page b.html being a child of a, etc ) to use an organisational chart to graph the hierarchy.
Is this possible?
-----------------------------------------------------------------------------------------------------------------------------------------------------------
in the following solution I have assumed the url string ending with /x.html
No comments:
Post a Comment