More elegant way of doing this - String functions?

[datanibbler]

Hi,

I often have filepath_variables that look sth. like this:

>> \\srn2\production\01_bimmelbam\bumbum\file.xls <<

These file_paths, as I said, are saved as variables in INCLUDE_files so as to have each piece of information in only one place.

Sometimes, however, I have to use the DIRECTORY command in the script or I have to build a search_mask for some loop,

so I only need the first part(s) of this:

>> \\srn2\production\01_bimmelbam\bumbum <<

I don't know how to do this in the most elegant way in QlikView - the best way, I think, would be to use a function to turn this string around, just cut off the (then first) part and turn it round once again - but to my knowledge, a function like REVERSE or other is not available in QlikView, is it?

Thanks a lot!

Best regards,

DataNibbler

[datanibbler]

And your help_file is really better than mine, it seems.

I will get the newest Client_version, but only when I get my new (old, repaired) laptop from IT - whenever that will be ...