Database Help - GoFuckYourself.com

StatsJunky · 12-02-2006, 07:25 AM

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

EdgeXXX · 12-02-2006, 07:45 AM

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

StatsJunky · 12-02-2006, 07:49 AM

Quote:

Originally Posted by EdgeXXX

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.

EdgeXXX · 12-02-2006, 07:57 AM

Quote:

Originally Posted by StatsJunky

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.

StatsJunky · 12-02-2006, 07:58 AM

Quote:

Originally Posted by EdgeXXX

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.

No prob. I droped you an ICQ.

Brujah · 12-02-2006, 09:49 PM

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

12-02-2006, 07:25 AM	#1
StatsJunky Confirmed User Join Date: Aug 2005 Location: Checking My Stats Posts: 639	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 __________________ erik AT suthnet.com

12-02-2006, 07:45 AM	#2
EdgeXXX Confirmed User Join Date: Nov 2005 Location: Secretely plotting a hostile takeover Posts: 5,816	So, are you wanting a program that will do this or something like an automated script? __________________ . . . . I have a sig

12-02-2006, 09:49 PM	#6
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	If you send me the files I can do it for you. Wouldn't take long. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com