Merge CSV files

[lostruler]

Guys,

How can I merge all .csv files from a folder in just one file?

- I have a lot of files at C:\BASE
---C:\BASE\sales1.csv
---C:\BASE\sales2.csv
---C:\BASE\sales3.csv
---....
---C:\BASE\salesn.csv

I just want to create a single file C:\BASE\All_sales.csv and exclude the others.

How can i do that?

[Gintaras]

Macro Macro2790

Code:

Copy      Help

str k

Dir d
foreach(d "C:\BASE\sales*.csv" FE_Dir)
,str path=d.FullPath
,out path
,str data.getfile(d.FullPath);; err ...
,
,k.addline(data)

k.setfile("C:\BASE\All_sales.csv")

not tested

[lostruler]

It worked perfectly!!!