Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Merge CSV files
#1
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?
#2
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
#3
It worked perfectly!!! Big Grin


Forum Jump:


Users browsing this thread: 1 Guest(s)