topic Re: Right substring in QlikView

Right substring

Anonymous — Tue, 07 Oct 2014 07:45:53 GMT

Good day.

How can i get name Finance from D:\Qvapplications\Finance.Qvw ?

Thanks

Re: Right substring

tresB — Tue, 07 Oct 2014 07:48:13 GMT

TextBetween('D:\Qvapplications\Finance.Qvw' , '\', '.',2) //updated

Re: Right substring

Anonymous — Tue, 07 Oct 2014 07:52:51 GMT

thanks, but it's very simple

i want to get this value universally (text between "." and last "\")

Re: Right substring

ashfaq_haseeb — Tue, 07 Oct 2014 07:54:57 GMT

Like this

=SubField('D:\Qvapplications\Finance.Qvw','\',3)

Regards

ASHFAQ

Re: Right substring

Peter_Cammaert — Tue, 07 Oct 2014 07:55:35 GMT

Something like:

=subfield(mid(vString, index(vString, '\', -1)), '.')

Note that this will return a partial filename if the filename contains multiple dots.

Re: Right substring

jagan — Tue, 07 Oct 2014 07:57:39 GMT

Hi,

Try like this

=SubField(SubField('D:\Qvapplications\Finance.Qvw' , '\', 3), '.', 1)

Regards,

Jagan.

Re: Right substring

Anonymous — Tue, 07 Oct 2014 08:06:01 GMT

i need to get text between last symbol "\" and "."

for example:

D:\Qvapplications\Finance.Qvw - Finance

D:\Qvapplications\Path1\Finance.Qvw - Finance

D:\Qvapplications\Path1\Path2\Finance.Qvw - Finance

thanks.

Re: Right substring

jagan — Tue, 07 Oct 2014 08:23:11 GMT

Hi,

Check this

=SubField(Mid('D:\Qvapplications\Path1\Finance.Qvw', Index('D:\Qvapplications\Path1\Finance.Qvw', '\', -1)+ 1), '.', 1)

Regards,

Jagan.

Re: Right substring

tresB — Tue, 07 Oct 2014 08:35:00 GMT

=TextBetween(StringYour, '\', '.',SubStringCount('StringYour','\'))

Re: Right substring

Anonymous — Tue, 07 Oct 2014 08:41:28 GMT

thank you!