8 Replies Latest reply: Oct 22, 2014 8:25 AM by Marcello Aondio RSS

    How to filter a .csv by the name

    Marcello Aondio

      Hi everybody,

      I have a .qvw application with a couple of .csv as datasource, the file are named like  CMT_201406.csv  , CMT_201407.csv and there is an FTP that places the new file ( eg. CMT_201408.csv ) every month in the same folder. I want that the application catch the last file and not the other ones. ( every file contains not only the data of the month, but the entire dataset from january till the current month ).

      In the script i have inserted the following line: right (FileBaseName(),02) as last2digit, in this way i have the last 2 digit of the file name, how can i set the load in order to catch the file in the folder with the last two digits higher?

      Thanks in advance