Possible to check file size before load?

[#1]

I am trying to load a set of XML extracts that we receive every night, however we receive empty 'shells' if no new data has been entered in the system. So what happens is we have 1KB files sitting on the server being ran and causing an error during the load. Other than setting the error mode to zero, I'd like to set up a parameter of: if the file >= 3KB, load, if not, skip.

Has anyone done this or something similar?

[rwunderlich · Accepted solution]

Take a look at the filesize( 'xyz.xls' ) function in Help.

LET vSize = filesize(myfile);

IF '$(vSize') > 3000 THEN

  LOAD * FROM myfile;

ENDIF

-Rob

[#3]

Perfect!