INDEX, substring, mid , trim ,left , right

[#1]

Hi guys,

I need to represent TOTAL NO oF VIEWS for a WEBPAGE as dimension. Since the webpage name is a Http:// .................................................... 

type of string, it takes a lot of space on teh chart and does not display properly.

How can i use correct string function to display only the last part of the page link??

e.g if i have a page link as https://portal.abcd/strategy/pages/depot/abcd/page/home.aspx

and . https://portal.abcd/strategy/pages/depot/abcd/page/webcommunication.aspx

which i want to display as only Home

only as webCommunication respectively on my chart x axis.

Please let me know how a correct string function can be applied on the field Page during Load.

Thanks!

[kaushiknsolanki · Accepted solution]

Hi,

     Try this code

Load Page,mid(Page,Index(Page,'/',len(KeepChar(Page,'/')))+1,Len(Page)-Index(Page,'/',len(KeepChar(Page,'/')))-5) as ABC inline [
Page
https://portal.abcd/strategy/pages/depot/abcd/page/home.aspx
https://portal.abcd/strategy/pages/depot/abcd/page/webcommunication.aspx
];

Have a look at the attched example.

Regards,

Kaushik Solanki

[#3]

Thanks  Kaushik.