3 Replies Latest reply: Sep 1, 2010 5:31 PM by Guest Guest RSS

    How can I check if a csv file physically exists?

      I have a loop where I generate a filename based on a date-value. The filename is representing a csv-file which should be loaded with a load statement, for example LOAD log20100212.csv . But not all generate filenames do physically exist, so that the LOAD script run into an error.

      Is there any possibility to check if a file physically exist before I try to use it for loading. In the most programming languages exist some functions like 'isfile()', checking if a file exist, but I found nothing equal in the script functions.

      Has anyone an idea?

      thanks Thomas