Reading a Text File

gmoney060 · October 30th, 2004, 12:48 AM

This is going to be a lot easier for me to show you then to try and explain it. This is the text file that I have to read, and it might change. The only thing that will change is the number of "records" that are red. The stuff in BLUE is really not in the text document, it is just to help you understand what is going on.

[u]Text File:</u>

Code:

DCIR 2.7 1c
****
04-10-749274
          No
****
Num   DCI Num      First Name Last Name
1     13032928     Name 1     Last Name 1
2     13012342     Name 2     Last Name 2
3     17345928     Name 3     Last Name 3
4     13171234     Name 4     Last Name 4
5     16153145     Name 5     Last Name 5
6     11234125     Name 6     Last Name 6
****
Sanctioning Num  Winning DCI  Loosing DCI  Round Something (dont know
04-10-749274     13032928     17345928     1     A
04-10-749274     17345928     13012342     1     A
04-10-749274     11234125     13171234     1     A
04-10-749274     13032928     17345928     2     A
04-10-749274     17345928     13012342     2     A
04-10-749274     11234125     13171234     2     A
****

So what my goal is to figure out how many wins everyone has. There DCI number is the "Social Securety Number" for this game. So I need to be able to "look that up" Then i need to store the number of wins that everyone had, and who they played. How would i do that in a text document?

happygv · October 30th, 2004, 01:31 AM

I would suggest you read that and populate in a DB if you can afford to have a DB, then it would be easier to query that against. For reading text/csv files, you may check this thread for some idea on that.

Importing from CSV File to SQL DB, Strange problem

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

gmoney060 · October 30th, 2004, 01:43 AM

This is what i am trying to do. I want my machine to upload the text file that i showed you before, every night at 12:00. This would be done by a scheduled task with windows. I like the database idea a lot, but I want it done TOTALLY automatically. So if it would upload the tx file or something i want it to be put in the database without ANY user interaction. is that possible? and how?