Friday, February 21, 2014

yogi_Extract Single Character Left Of / Left Of x.html At The End Of The URL String

                                         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
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/ 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