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 |
All times are GMT +1. The time now is 07:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com