Link to home
Start Free TrialLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

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
Avatar of yo_bee
yo_bee
Flag of United States of America image

Do you want to read each file into a single csv file?
Do all the csv files have the same columns?
Avatar of Jim Metcalf

ASKER

yes
one big csv file
yes they do have the same columns
ASKER CERTIFIED SOLUTION
Avatar of yo_bee
yo_bee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
could you write the cmd for me

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?

GCI -Path c:\files -Filter *.csv | %{Gc -Path $_.fullname | Select -Skip 1 | ac Test.csv}

Open in new window