Database Help
 

I have 7 individual CSV files that are for 7 months of data. I want to combine them into one CSV file. The individual files contain data,number. Not all indivdual files have the same data or first field so I need to be able to compare the first field and output the number for each second field.

Tough to explain but here's a little example.

June
data1,56
data2,78
data9,72

July
data1,87
data2,67
data7,52

Etc.

Would like the output formatted like.

data1,56,87
data2,78,67
data9,72,0
data7,0,52

Anyone that can give me a hand or write me something? ICQ 265054864

So, are you wanting a program that will do this or something like an automated script?

Program or script. Doesn't matter I need to do it daily for different data sets.

Hmmm, well, I personally use UltraEdit32 (using custom macros) for things like that. As far as an exact walkthrough for something like that, you'll have to wait till at least halfway through my next cup of coffee before I could help you with that. :winkwink:

No prob. I droped you an ICQ.

If you send me the files I can do it for you. Wouldn't take long.