[windows2000] Re: Text file parsing
- From: "Chris Berry" <compjma@xxxxxxxxxxx>
- To: windows2000@xxxxxxxxxxxxx
- Date: Mon, 12 May 2003 12:45:23 -0700
>From: Rick Fogarty [mailto:rick@xxxxxxxxxxxxx]
>This is more of a general programming question, but I thought I'd ask here
>due to the knowledge.
>
>I have the following text file that looks like this:
>
>FIRST M. LAST
>
>STREET
>
>TOWN NC 28327
>
>XXX-XX-9533 05/07/2003
>
>
>
>
>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
>
>I need to parse this and place it into a db... Any suggestions?
>Thanks,
>Rick
I'd use perl for this, it's pretty much the ultimate text processing
language and it has database modules as well so you could do everything with
one program.
Chris Berry
compjma@xxxxxxxxxxx
Systems Administrator
JM Associates
"This email is ROT26 encrypted, by reading it you are in violation of the
DMCA, and should turn yourself in to the authorities immediately."
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
==================================
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
Other related posts:
