Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i have few .csv files with file name filename1_20181025.csv, filename1_20181026.csv, and filename1_20181026.csv.
now i only want to start the loading from 20182026 onwards. How should i write in loading script??? please help.
Rgds
Jim
Hi Jim, I think you can read all files from that folder and do a check for each filename, ie:
SET vDateStart = 20181026;
For each filename in filelist('path\*.*')
LET vFileDate = TextBetween('$(filename)', '_', '.')
IF $(vFileDate)>=$(vDateStart) THEN
// Load file
LOAD...
ENDIF
NEXT