Right substring

[Anonymous]

Good day.

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

Thanks

[tresesco]

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

[Anonymous]

thanks, but it's very simple

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

[ashfaq_haseeb]

Like this

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

Regards

ASHFAQ

[Peter_Cammaert]

Something like:

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

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

[jagan]

Hi,

Try like this

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

Regards,

Jagan.

[Anonymous]

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.

[jagan]

Hi,

Check this

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

Regards,

Jagan.

[tresesco · Accepted solution]

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

[Anonymous]

thank you!