10 Replies Latest reply: Jan 29, 2015 9:33 AM by Friedrich Hofmann RSS

    More elegant way of doing this - String functions?

    Friedrich Hofmann


      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