from multiple csv files to a single xls - with one field as primary key

A

A.lagolep

Joined
Nov 8, 2005
Messages
1
Reaction score
0
Hi all,
I do not know how to start programming on that case :

I have several csv files formatted like the following :
identifier / last update / content ....

I would like to merge all of them into one single file. If an identifier is found in several files, I want to take the latest "last update" only.

What do you think could be the best algo for this ?

Thks,

AL.


Examples :

file 1 :
id1 / 051108 / blabla
id2 / 051107 / blabla
id3 / 051107 / blabla
id4 / 051108 / blabla

file 2 :
id5 / 051108 / blabla
id1 / 051105 / blabla
id1 / 051104 / blabla

....

What I would like at the end is an unique file with

id1 / 051108 / blabla
id2 / 051107 / blabla
id3 / 051107 / blabla
id4 / 051108 / blabla
id5 / 051108 / blabla

--> there is an unique identifier which is the last updated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Give parameters to a HelpFileName string 1
Importing a single cell from one .xls to another 2
How to simply export a single sheet to a new .csv file? 2
Still more on loading a .CSV into a .XSLS 15
File Properties Location retrieve to refresh background query? 1
Access To Text For Webpage 1
Need to Export All Worksheets from All Workbooks in Folder to Separate FIles not as CSV Files 2
Add .csv File Name When Importing Multiple Files Into a Table 0

Top