AnsweredAssumed Answered

import scrip variable file names

Question asked by mjroberson on Apr 3, 2015
Latest reply on Apr 3, 2015 by philmodjunk


import scrip variable file names



I have a few hundred *.csv files to import they are all structured the same YYYYdailyXXX.csv where YYYY = year (1982-2014) and XX = site number (001-270).  I wrote and an import script with local variable set for YYYY and XXX but it does not work.  

Set Variable[$date; Value;"date]

Set Variable[$stationID;"station.csv"]

Import Records [No Dialog;"$date"daily"$stationID"]

Any suggestions for how to make the year and station # variables?

thanks  Mark