Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

string -CSV file-

Hi,

I have currently a question about the use of the string function. I need only a string of a CSV file for my evaluation filename.

Instantaneous,  I`m requesting the filename with this command: MID(File_Name,21,1) as drive.

The title of the CSVFile is created like this: \\000\BND$;"20,20" or \\003\Share_BND;"64,21". I only need the string "BND $" and "Share_BND" for the filenames.

Has anybody to make one`s point for me to  solve this riddle?Smiley Wink

Thanks and have a nice weekend!

Greetings Greg

2 Replies
MVP
MVP

Re: string -CSV file-

There are multiple possible approaches, depending on the possible file names you get.

Have a look at the String functions in QV help,there are a lot of useful functions for extraction.

For example, here are two ways to get your result:

LOAD *,

  TextBetween(Filename,'\',';',3) as Result1,

  SubField(SubField(Filename,'\',-1),';',1) as Result2;

LOAD * INLINE [

Filename

\\000\BND$;"20,20"

\\003\Share_BND;"64,21"

];

Not applicable

Re: string -CSV file-

Hi Swuehl,

thanks for your quik answer. I will try your advise. Call you later, if it works..