topic Re: Detecting FileNames in App Development

Detecting FileNames

Runo_ooa — Wed, 10 Jun 2020 16:03:02 GMT

Hello all,

I have txt files around more than 500, but some of them are empty 😕 , can i reveal which of them are empty txt files? i done something like that but couldnt achive it

Set Error Mode = 0;

LOAD

FROM [lib://folder/*.txt]

if ScriptError = 11 then

Load

filename() as EmptyTxt

autogenerate 1;

Re: Detecting FileNames

Miguel_Angel_Baeyens — Fri, 12 Jun 2020 12:37:45 GMT

What about something like:

Files: // only the header LOAD * INLINE [ FileName ]; FOR EACH vFile in FileList([LIB://Folder/*.txt]) CONCATENATE (Files) '$(vFile)' AS FileName AUTOGENERATE 1; NEXT vFile

And then repeate a FOR loop using the "Files" table.