ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import file information (https://www.excelbanter.com/excel-discussion-misc-queries/228565-import-file-information.html)

nickodemos

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