I have multiple csv files of large size in a folder, say
Nov 13, 2018 To merge Microsoft Excel files together, it is best to save them as CSV files first. Open the Excel files and in the menu bar, click File, then Save As. In the Save as type drop-down list, select CSV (comma delimited) (.csv) from the list. Additional information about creating a CSV file. Mar 11, 2016 Merge CSV files using Windows CMD. This approach uses the Windows Command line Copy command. Open the folder which should contain your CSV or TXT files. Open in Windows Explorer the folder containing CSV or TXT files to be merged. These should be without headers or only the first file should be with headers.
And if I have to combine (append) all of them using cmd, I know that I have to use
My question is what if I have to combine the csv files which has the name 'file' in it which are file1.csv, file2.csv, file3.csv in this case.
1 Answer
@aschipfl already answered this in a comment, but I am answering this with some explanations:
The above purely runs a single copy command for all file*.csv files and once off opens targetfile.csv and appends each file's content to it.
Additionally, if you have 100s of different filenames all together with csv extensions, you can also do this and ensure you exclude targetfile.csv
The exact same line can be used in a batch file by simply adding an additional % to the variables.
Not the answer you're looking for? Browse other questions tagged windowscsvcmdmerge or ask your own question.
This topic contains 23 replies, has 5 voices, and was last updated by
Merge Csv Files Windows 10 Windows 10
Can you post the first 3 or 4 rows of each file?
Can you tell us the row count of each file? Clean install windows 10 on ssd.
What do you mean 'rows out of order'?
What are you looking for as desired output?
ComputerName, LastUser, UserLastLogin, Manufacturer, MemoryGB, DriveC, FreeC, DriveD, FreeD, DriveE, FreeE , etc??
Where does the data from the 2 csv files originate? Other scripts?
You should just be able to Import-CSV the second file and pipe it to Export-CSV using -Append, if the two have the same columns.
So you aren't looking to append csv2 to csv1. csv2 doesn't contain the computername? Could it? I'm not sure how you are building the drive.csv file.
I realize I probably don't have the whole story here – but there are some questionable things in the script you were given — here are some suggestions / comments:
This should get you to the point where your drives file includes the computer name. Once you have that, combining them the way you want becomes more reliable, rather than leaning too hard on the rows matching up from 2 separate files. Lots of room for error there.
So I posted a reply to the script that was given to you — there are some things that look a little bit off there. Most importantly, this:
Login with your Google Play Store account.
The script selects all of the drive* and free* properties, but not the computer property. Then, the script sorts on computer – however, it doesn't exist in the list of exported properties. I think if you add select-object computer, driveB,FreeB... your output file will get you computername.
Once you have that – getting to the combined file you are looking for will be much easier.
Some comments / suggestions on the code you were given:
There are a couple things you need to combine objects.
- Most important. Both objects need to have a unique value that you can join on. The computername or serial number for instance
- The same properties for each row
Look at this example:
If you run this code, just look at $obj2:
Notice that drive D is missing even though you can see we created D properties for Computer2. In order to see those properties, they need to exist in BOTH objects. You can do this using Select-Object to create properties for all objects. This gives you result like this:
There are many ways to do things. You could also have a Drives property with all of the drives a system. You could also use a Join-Object function (there are several iterations) to Join on the computername. The key is you need to have a property in both objects to do the join.
James,
Would it be possible to post examples of the 2 input files – with 3 or 4 dummy data entries as well as a desired output file with that data?
I think I am not fully understanding your requirements with the 'function flip' etc
File Merge Windows 10
The topic ‘import/combine two csv files’ is closed to new replies.