Link to home
Start Free TrialLog in
Avatar of aentice
aentice

asked on

Display alias of a @ViewTitle instead of name.

I need to display an alias of a view intead of a name of the view using @ViewTitle.
ASKER CERTIFIED SOLUTION
Avatar of Bill-Hanson
Bill-Hanson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Felix Grushevsky
@viewtitle returns text list if view name has aliases
use @subset to get alias name from the returned list.  
for example
@subset(@viewtitle;-1) returns the very last alias
or
@subset(@viewtitle;1-@count(@viewtitle))
returns all aliases but not view name
actually, correction to the last example

@if(
@count(@viewtitle)=1;@viewtitle;
@subset(@viewtitle;1-@count(@viewtitle)))
Avatar of aentice
aentice

ASKER

Perfect! Your no.2