asked on folder with many csv files... want to combine
can someone tell me how to combine a folder with about 100 csv files
powershell would be great...
id like the script to not care what the name of the files is
powershell would be great...
id like the script to not care what the name of the files is
Powershell
Last Comment
yo_bee
ASKER
yes
one big csv file
yes they do have the same columns
one big csv file
yes they do have the same columns
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
could you write the cmd for me
the files are going to be
in c:\files
the files are going to be
in c:\files
all you need to do is replace G:\Documents\TestFolder with c:\files.
Where do you want the output to go?
Where do you want the output to go?
GCI -Path c:\files -Filter *.csv | %{Gc -Path $_.fullname | Select -Skip 1 | ac Test.csv}
Do all the csv files have the same columns?