Re^2: Process and combine two CSV files into one

[DrAxeman]

Sorry. That was a horrible way to ask for help on something. Now that I'm trying, I find it's harder to ask properly than I thought.

My CSV files look like:

IP,Domain,ServerName
10.160.0.8,0,
10.160.0.9,0,
10.160.0.10,EURORSCG,ERWWDC1
10.160.0.11,EURORSCG,ERWWSQLWEB
10.160.0.12,EURORSCG,ERWWSEARCH
10.160.0.13,EURORSCG,ERWWNAB
10.160.0.14,EURORSCG,ERWWCOMMUNITIES

and

IP,DaysUptime,OS,RAM,OSSP,InstallDate,CPUSpeed,CPUCount,CPUType
10.160.0.10,19,Microsoft_Windows_2000_Server_Domain_Controller,1024,4,
+12_2_2003,995,1,Intel_Pentium_III
10.160.0.11,266,Microsoft_Windows_2000_Server,2048,3,11_21_2003,3000,4
+,Intel_Xeon
10.160.0.12,21,Microsoft_Windows_2000_Server,1024,3,11_24_2003,1000,1,
+Intel_Pentium_III
10.160.0.13,25,Microsoft_Windows_2000_Server,1024,3,11_20_2003,1000,1,
+Intel_Pentium_III
10.160.0.14,3,Microsoft_Windows_2000_Server,1024,4,8_28_2002,1000,1,In
+tel_Pentium_III
10.160.0.15,25,Microsoft_Windows_2000_Server,1024,4,5_23_2003,995,2,In
+tel_Pentium_III

The files get inputted as hash arrays, %hosts and %sysinfo. I'd like to combined both into %combined, using the IP column as a key. I'd like it to look like:

IP,Domain,ServerName,DaysUptime,OS,RAM,OSSP,InstallDate,CPUSpeed,CPUCo
+unt,CPUType
10.160.0.8,0,
10.160.0.9,0,
10.160.0.10,EURORSCG,ERWWDC1,19,Microsoft_Windows_2000_Server_Domain_C
+ontroller,1024,4,12_2_2003,995,1,Intel_Pentium_III
10.160.0.11,EURORSCG,ERWWSQLWEB,266,Microsoft_Windows_2000_Server,2048
+,3,11_21_2003,3000,4,Intel_Xeon