Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 30th, 2004, 12:48 AM
Authorized User
Join Date: Mar 2004
Posts: 84
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to gmoney060 Send a message via MSN to gmoney060
Default Reading a Text File

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>
DCIR 2.7 1c
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?

Old October 30th, 2004, 01:31 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

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.

- Vijay G
Strive for Perfection
Old October 30th, 2004, 01:43 AM
Authorized User
Join Date: Mar 2004
Posts: 84
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to gmoney060 Send a message via MSN to gmoney060

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?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reading from a Text file for Login and Password.. zabzoub1 Pro Visual Basic 2005 2 July 4th, 2007 01:03 PM
reading froma text file -- what directory paulchwd Apache Tomcat 0 March 13th, 2007 11:06 AM
reading text file Regornil JSP Basics 2 October 27th, 2004 02:02 AM
Reading ASCII data from text file. LordBeholder VB How-To 2 June 25th, 2004 05:50 PM
Reading from a text file and writing to a Binary 1 scott01 C++ Programming 0 July 28th, 2003 03:59 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.