Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
a,
b,
c
FROM [lib://folder/*.txt]
if ScriptError = 11 then
Load
filename() as EmptyTxt
autogenerate 1;
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.