string fun ?

[Anonymous]

path:

\\qlikview\qliktech\dashboard

i have used subfield function here like

subfield(path,'\',1)  ?  what is output  ?

i want my subfield fun return has dashboard ?  what to do ?  how to do?

[tresB]

Try:

subfield(path,'\',-1)

[ashfaq_haseeb]

Try like below

=subfield('\\qlikview\qliktech\dashboard','\',5)

Regards

ASHFAQ

[its_anandrjs]

Try some of this

This return qlikview

=subfield('\\qlikview\qliktech\dashboard','\',3)

This return qliktech

=subfield('\\qlikview\qliktech\dashboard','\',4)

This return dashboard

=subfield('\\qlikview\qliktech\dashboard','\',5)

Regards

Anand

[MarcoWedel · Accepted solution]

subfield(path,'\',1) returns an empty string as there is nothing before the first backslash.