Amazing!! It worked!! I was modifying excel sheets in order to get there.
And if i wanted to show only what's in between the /'s ??
On the Excel sheet what I did was:
1) Strip anything after the slash (which you showed me how to do here)
3) Strip the final slash
So finally, http://www.graphlib.net/ will show up in QV as graphlib.net
Is there any way to get that done without having to do it manually every time i get a new Excel Spreadsheet??
Thanks so much !!
Thanks! But that cut out parts of the link
This is how i solved it in the Load Script:
left(url, index(url,'/',3)) as TestURL2,
lower(trim(subfield(subfield(subfield(subfield(subfield(TestURL2,'http://www.'),'https://www.'),'https://'),'http://'),'/'))) as ShortURL