Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day.
How can i get name Finance from D:\Qvapplications\Finance.Qvw ?
Thanks
=TextBetween(StringYour, '\', '.',SubStringCount('StringYour','\'))
TextBetween('D:\Qvapplications\Finance.Qvw' , '\', '.',2) //updated
thanks, but it's very simple
i want to get this value universally (text between "." and last "\")
Like this
=SubField('D:\Qvapplications\Finance.Qvw','\',3)
Regards
ASHFAQ
Something like:
=subfield(mid(vString, index(vString, '\', -1)), '.')
Note that this will return a partial filename if the filename contains multiple dots.
Hi,
Try like this
=SubField(SubField('D:\Qvapplications\Finance.Qvw' , '\', 3), '.', 1)
Regards,
Jagan.
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.
Hi,
Check this
=SubField(Mid('D:\Qvapplications\Path1\Finance.Qvw', Index('D:\Qvapplications\Path1\Finance.Qvw', '\', -1)+ 1), '.', 1)
Regards,
Jagan.
=TextBetween(StringYour, '\', '.',SubStringCount('StringYour','\'))
thank you!