Everybody known as follwing ...How to load all files with ftp
Anybody a suggestion?
// example 1 - list all log related files on disk EXT = 'log' sub DoDir (Root) for each File in filelist (Root&'\*.'&EXT) LOAD @1, @2, @3 FROM '$(File)' (txt, codepage is 949, no labels, delimiter is ',', msq); next File end sub
call DoDir ('C:\T')
// example 2 - load log with ftp
set filename=2010-02-08_1123.log; LOAD @1, @2, @3 FROM [ftp://$$$:$$$@11.6.11.2/$(filename)] (txt, codepage is 949, no labels, delimiter is ',', msq);
for each File in filelist ('ftp://***:***@211.236.4.1/*.log') LOAD @1, @2, @3 FROM 'ftp://***:***@211.236.4.1/$(File)' (txt, codepage is 949, no labels, delimiter is ',', msq); next File