how to load exclude data file to load?

[jim_chan]

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

[rubenmarin]

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