Diff 2 csv files

Start by looking up what a CSV is. It is not a collection of strings it is a data structure. Working with it as strings will fail most of the time. VB also uses a CSV as a data object so you are clearly not an experienced or trained VB programmer or you would know this. Guessing never works out well. Please understand that this advice is from some9one with deep experience in both PowerShell and VB languages.

I have been programming for over 40 years and this task is trivial if you learn the basics of programming beyond a casual or entry level. The following free book is0one of the best for quickly learning PowerShell correctly.

This ls why I am posting this and will get you up to speed with PowerShell quickly. Thanks for your response jrv, I just got off work, so I haven't had time to look into the compare-object docs yet. On a previous attempt I did import the CSVs into variables, but still had a few quirks to figure out. I was hoping to get some quick recommendations. You are correct, I'm not a trained or experienced VB programmer. I took a few VB6 courses in college, but majored in networking.

I'm occasionally asked to give it the old college try for certain tasks, and I'm not planning on changing professions. I know what I'm trying to do can also be achieved through VBS and FSO using a few string manipulations, I've successfully dabbled in it before but without the need for comparisons and separate results. With the export of the comparison results as is, I can technically do the rest in VBS, but it will be longer and ugly and obviously not 40yr professional level work.

Unfortunately, I'm doing the best I can with my limited skill set and available time. The main issue is that you think using vague VB5 collage examples and have no experience in progr4amming.

What you know is not programming it is just simple coding at teh lowest level. To be a network technician you will need to learn PowerShell as VBS is obsolete and cannot do most network things. There is no support and no future changes to VBS will be made.

While Rich' example may work the solution can be had using three lines of code. Import-Csv and Compare-Object can do that simply. You will need to learn PowerShell in order to become a competent network engineer. It is a requirement now in nearly all major corporations. Are you and engineer or just a BA in something else? Are you currently working as an intern? Hi jrv, you're correct in regards that I only know low level coding.

I try to implement simple solutions and not over complicate them. You're completely wrong about needing to know PowerShell to become a competent network engineer. PowerShell is simply an optional tool for automation among a sea of other solutions , and is not fundamental to networking what so ever Cisco, Aerohive, Aruba, etc all have their own management solutions. When there is a circumstance that may require coding, I certainly try and exhaust my resources on my own before recommending a purchase order.

Latest version Released: Feb 23, Navigation Project description Release history Download files. Project links Homepage. Maintainers simonw. Project details Project links Homepage. Download files Download the file for your platform. Files for csv-diff, version 1. Close Hashes for csv-diff File type Wheel. Python version py3. Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search.

I need to compare two csv files in windows7. How can I proceed to achieve this. I want to see the differences in both the files , like we can use tkdiff in Linux. Here is another option which I found very useful, as mentioned here :. As an aside, I found findstr far more accurate and the output more readable than fc. You might get an out of memory error on larger files. In this case, I've had to turn to Python and dataframes. Just a friendly heads up I imported both of them in my excel sheet.

I sorted them first by column c and then by column b and then by column a. You can go in any order you like. You can also do the same thing with Powershell, which can be useful if you're in a read-only folder. You can launch Powershell directly in your folder without navigating via cd, by typing powershell in the folder's address bar.

I had this issue and for fun I tried writing some powershell code to generate a "per column" diff. It is embarrassingly slow, but it solved my problem nicer very wide CSV file, so regular diff was really hard to interpret.

Call Compare-Csv with the files you need. Stack Overflow for Teams — Collaborate and share knowledge with a private group.