Re: Compare 2 CSV files and create a new CSV file out of comparision

The proper way to do it is to read the first file, and use a hash to store the contents. Use the vm_name column as key and the whole row as a value.

Then read the second file line by line, and look up the vmname in the hash you created earlier, and print the joined columns to the third file.

Comment on Re: Compare 2 CSV files and create a new CSV file out of comparision

Replies are listed 'Best First'.
Re^2: Compare 2 CSV files and create a new CSV file out of comparision by slayedbylucifer (Scribe) on Jul 02, 2012 at 09:23 UTC
Hi. could you get me a sample code structure. Sorry, I am asking for too much, but I didn't quite understand "Use the vm_name column as key and the whole row as a value." part. Thanks again for your time.	[reply]
Re^3: Compare 2 CSV files and create a new CSV file out of comparision by moritz (Cardinal) on Jul 02, 2012 at 10:31 UTC
See perlintro or perldata for a description of hashes. "key" and "value" are terms used together with hashes. If you search for join files or similar keywords, you'll find quite a bit of example code, for example join mutiple files on first column and join - join two files according to a common key. Perl 6 - the future is here, just unevenly distributed	[reply]