Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have loaded n no. of files but format of some files is different so i need to get the name of these files which have format issue.
Plz help u guys have any idea to resolve
Hi Rajni,
I don't have Winrar here. What kind of formatting are you referring to? In what respect can the files differ?
Load the filenames when ScriptError<>0, like;
LET vErrorLog=NULL();
SET errormode = 0;
LOAD *,
FileBaseName() as Filename
FROM
[..\Desktop\CRM\Test\CRM*.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);
if ScriptError <> 0 then
LOAD *,
FileBaseName() as ErroFilename
FROM
[..\Desktop\CRM\Test\CRM*.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);
ENDIF