I am trying to use Sbasic to read a whole bunch of csv files to import data. After trying to use the file commands like fileseek, filereadln etc I realized that if I just append the data from all the files into 1 file I can then easily use sesame built in import feature. My problem is, is there an easy way to use sbasic or something else to loop through all the files with the append command

Type 001.csv >> bigfile
Type 002.csv >> bigfile
Type 003.csv >> bigfile
Type 004.csv >> bigfile

And so on till 999

Something like this but with a loop

Var vfilenumber as int

Vfilenumber = 001

Type vfilenumber.csv >> bigfile

Vfilenumber = (Vfilenumber + 1)

Type vfilenumber.csv >> bigfile


Thanks for any help you can offer.

ray the reaper,

Thank you for the help but I am still a little confused.

Question 1
In-between  this line
vFileName = @Right("000" + @Str(vFileNumber), 3) + ".csv"

and this line
vFileNumber = vFileNumber + 1

Is were my action should be placed correct?


Question2

Should I be shelling out to the operating system and using something like
type vFileName >> bigfile.csv

or should I be using  something like

filereadln(vFileName, bigfile.csv)


Thank you for your help

example

var vFileNumber as Int
Var vFileName as String

vFileNumber = 1

While vFileNumber < 1000  // This is saying do what is in the curly brackets until 1000

{
vFileName = @Right("000" + @Str(vFileNumber), 3) + ".csv"
//Use vFileName to do what you need to

// my action command here

vFileNumber = vFileNumber + 1
}

Thank you Ray The reaper for the help.

Another forum member helped me with the code below that does the trick. He has however suggested that  I add sbasic that checks to make sure the files are in the directory and also rename them as it goes to eliminate the chance of accidental duplication.
(He also said it would be cooler to do it all in sbasic and I should go to the class in Ohio to learn more)

This is the working file

var vFileNumber as Int
Var vFileName as String
Var vFileNameD as String
var vshellfile as string

vFileNumber = 1

While vFileNumber < 1000  // This is saying do what is in the curly brackets until 1000

{
vFileName = @Right("000" + @Str(vFileNumber), 3) + ".csv"
  //Use vFileName to do what you need to

     vFileNameD = ("type c:\buildfile\" + (vFileName) + " >> c:\ buildfile\ Bigfile.csv")
     //writeln(vfilenamed)      
       vshellfile = @shell(vfilenameD)

vFileNumber = vFileNumber + 1
}