Import file information
I am a moderator at a website and part of my job is to look for
people who have a bad upload ratio. Right now I am downloading this
information with a macro program and when I am done cleaning it up I
have this:
1spice,Members,04/12/2008 08:19:13,22/04/2009 11:44:51,Australia,0.94
77raptor,Members,11/11/2008 17:13:06,22/04/2009 14:38:52,Canada,2.12
And I also go a step further to find the low ratio's by making them
look this way:
(0.25)VAGMAVRO
(0.26)erekose
What I would like to do is to be able to import the information
directly from the first example with today's date as a column. So I
would like to do daily imports from a CVS file where it looks like
this:
Username Userlevel 22Apr2009 23Apr2009
3x2y1z Members 0.23 0.45
badmule Members 1.65 1.67
Is there a way to import daily files so that it goes to the persons
name but added to today's column? Right now I am working with text
files and it gets to be difficult to read as I add more days to a
single file with over 400 people.
nickodemos
|