[windows2000] Re: Text file parsing
- From: "Rick Fogarty" <rick@xxxxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Mon, 12 May 2003 16:34:39 -0400
Glen,
I figured the same thing... I guess I should have stated my question a =
bit
more clearly.
In the text file, the name and address fields are not consistent. =
Sometimes
they have a space between the name and address, sometimes not. However, =
I
did peruse the text files and found that after the SSN, there are 17 =
spaces;
there are always 4 lines after the address and then the classes start; =
and
there are always 26 lines between the last line in the address and the =
first
line in the next address (this should include the 14 lines for classes =
too).
With that said, in logic terms, how should one determine the address
problem. How will I know, if I'm in a for loop, to parse the second =
line of
the file and assume that it's the address and not a company?=20
Yes, the details line did wrap... Getting that info shouldn't be a
problem...
-----Original Message-----
From: windows2000-bounce@xxxxxxxxxxxxx
[mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Sullivan, Glenn
Sent: Monday, May 12, 2003 3:14 PM
To: 'windows2000@xxxxxxxxxxxxx'
Subject: [windows2000] Re: Text file parsing
Rick,
Is the format always the same? i.e.... is there always the same number =
of
lines of address, the same number of lines of phone number, and one line =
(I
am assuming the detail lines wrapped) for each line item?
.vbs can do what you want...
Open a text file for input. Read each line, and depending on which =
number
line it is, parse it appropriately.
Email an example text file to me as an attachment and I will whip =
something
up for you to at least be able to play with.
Glenn Sullivan, MCSE+I MCDBA
David Clark Company Inc.
-----Original Message-----
From: Rick Fogarty [mailto:rick@xxxxxxxxxxxxx]
Sent: Monday, May 12, 2003 2:58 PM
To: W2K
Subject: [windows2000] Text file parsing
This is more of a general programming question, but I thought I'd ask =
here
due to the knowledge.
=20
I have the following text file that looks like this:
FIRST M. LAST
=20
STREET
=20
TOWN NC 28327
=20
XXX-XX-9533 05/07/2003
=20
=20
=20
EDU 3066 8802054 EFFECTIVE TEACHER TRAINING 09/06/88 =
11/08/88
30 S 3.0
EDP 3007 9002077 INTRO TO WORD PROCESSING 09/12/90
10/24/90 21 S 2.1
EDP 3007 9002071 ADVANCED WORD PROCESSING 10/31/90 =
12/05/90
21 S 2.1
EDU 3050 9101044 TEACHER RENEWAL PACKAGE 06/04/91 =
06/27/91
24 S 0.0
EDU 3066 9101065 CLASSROOM MOTIVATION AND DIS 07/08/91 07/11/91 =
0
S 0.0
EDU 3068 9103009 THE ADOLESCENT
10/29/91 12/10/91 21 S 2.1
EDU 3068 9103053 PARENTING
01/07/92 03/10/92 30 S 3.0
=20
I need to parse this and place it into a db... Any suggestions? Thanks,
Rick
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Rick Fogarty
Coordinator, Technical Support and Computer Servicing
Sandhills Community College
3395 Airport Rd
Pinehurst, NC 28374
1(910) 695-3943
Fax 1(910)695-1823
rick@xxxxxxxxxxxxx
http://www.sandhills.edu <http://www.sandhills.edu/>=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
==================================
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
Other related posts:
