Date: Wed, 12 Mar 2008 21:29:56 -0400
Reply-To: "Pearmain, Michael" <MPearmain@doubleclick.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Pearmain, Michael" <MPearmain@doubleclick.com>
Subject: Re: Reading text data with
Content-Type: text/plain; charset="iso-8859-1"
I've said it before and i'll say it again...
use python a small program will do this
-----Original Message-----
From: SPSSX(r) Discussion on behalf of Roberts, Michael
Sent: Wed 3/12/2008 5:57 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading text data with
Thank you all for responding. Here is what the simulated data looks
like, warts and all! The second set of header data is missing the suite
information, so there are only 4 lines of data:
1RUN DATE: 02/06/08 blah blah MANAGEMENT INFORMATION
SYSTEM PAGE: 1
blah GROUP blah PROJECT
AD HOC 08-035
-blah BASE: 0100053 blah blah INC.
1234 WEST blah STREET
SUITE 123
TAMPA ,FL 33607-4173
-blah: 010005300 COUNTY: 29 COUNTY DESCRIPTION: HILLSBOROUGH
-INDIVIDUAL NAME ADDRESS
TYPE TPI TOMY ZIP STATUS
PHONE IND BDATE EDATE
+_______________________________________________________________________
_____________________________________________________________
123456700 blah blah INC blah blah 1234 W blah
AVENUE TAMPA FL 33000-0000
90 1598841579 1 555-555-5555
07/01/06 99/99/99
543210101 Doe, John J., Md. 1234 N blah STREE
PLANT CITY FL 33555-4302
27 1003804675 1 123-456-7890
07/01/06 99/99/99
1RUN DATE: 02/06/08 blah blah MANAGEMENT INFORMATION
SYSTEM PAGE: 1185
blah GROUP blah PROJECT
AD HOC 08-035
-blah BASE: 0150009 more blah blah, INC
5678 SW ATH STREET
0CORAL GABLES ,FL 33134
-blah: 015000900 COUNTY: 06 COUNTY DESCRIPTION: BROWARD
-INDIVIDUAL NAME ADDRESS
TYPE TPI TOMY ZIP STATUS
PHONE IND BDATE EDATE
+_______________________________________________________________________
_____________________________________________________________
011234450 Junior, John DO blah blah 3456 S Blah ROAD
FT LAUDERDALE FL 33333-0000
26 1235128794 1 777-123-3456
07/01/06 99/99/99
023456700 Brown, John A The blah Group 1000 W Anywhere RD
CORAL SPRINGS FL 33000-0000
25 1740275528 1 555-444-5555
07/01/06 99/99/99
TIA
Mike
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Richard Ristow
Sent: Tuesday, March 11, 2008 8:46 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading text data with
At 07:44 PM 3/11/2008, Roberts, Michael wrote:
[notes on data layout omitted]
>The second set of data is on two lines (two lines make a case), and
>includes a field header for each variable, however. One twist is
>that the header data is not consistent - while I show five lines of
>data, sometimes one of those lines is not included - sort of like an
>additional address element that does not exist for an address. [And]
>I need to keep the header information,
It looks like Gene's onto this one; but, it could be clearer if you'd
post a few cases, including ones with differing numbers of header lines.
Right now, I'd think about using an INPUT PROGRAM, but I haven't seen
your data, nor looked at your problem as hard as Gene has.
--
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.7/1324 - Release Date:
3/10/2008 7:27 PM
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
====================To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
