PDA

View Full Version : Merging .CSV files...how?

TrickyDik
05-11-2009, 04:12 PM
I have 2 .csv files. Each file contains the header of 'product_id' in cell A1.

Underneath the 'product_id' in each file is each of the Product I.D. numbers, however, they are not in numerical order (1,2,3,4...) and neither file contains the same Product I.D. number in the same cell (i.e. file1.csv has the I.D. number of '54' in cell A2 whereas file2.csv has '54' located in cell A182).

Unfortunately for me there are unique columns of data in both files that need to be displayed in one file. Now this would be simple if the Product I.D. was in numerical order in each file, or if both files contained the same Product I.D. in the same cell, but neither is the case in my scenario.

How do I go about merging the 2 files so that the unique columns of each file are merged into 1 single csv file?

This would be a life saver! Help is very much appreciated!
method
05-11-2009, 04:47 PM
Can't you copy the data from 2.csv to 1.csv and paste it into the bottom of 1.csv's data. Then sort whatever column you want.
TrickyDik
05-11-2009, 04:50 PM
Can't you copy the data from 2.csv to 1.csv and paste it into the bottom of 1.csv's data. Then sort whatever column you want.

Yes, but that would be the super super lengthy way of doing it. There are roughly 1,500 rows of data for each file. To match up the data and copy it over one by one is simply too lengthy a process.
-=The Boss=-
05-11-2009, 05:03 PM
time to write a macro...
TrickyDik
05-11-2009, 05:08 PM
time to write a macro...

:unamused: if that's the case!
-=The Boss=-
05-11-2009, 05:12 PM
Its the only way I can think of doing it.

Or do data-filter-auto filter and a lot of Ctrl C Ctrl V
TrickyDik
05-11-2009, 05:14 PM
The program Synkronizer seems to be exactly what I need based on the free trial, but the key feature needed is not available until purchased.
method
05-11-2009, 05:23 PM
Exeter wont pay for it? Can't be all that expensive.
-=The Boss=-
05-11-2009, 06:06 PM
bit---torrent
TurboRush
05-11-2009, 06:18 PM
Have FreakyB whip up a quick Java app... can probably be done in 30 minutes.

I use to do it all the time.
TrickyDik
05-11-2009, 08:32 PM
Thanks be to eb50 for helping me out.

/thread
TurboRush
05-11-2009, 09:04 PM
i thought randy was a vb programmer? oh.. vbasic.. not v bulletin lol

VD programmer?
-=The Boss=-
05-12-2009, 08:36 AM
B we dont program the D's