J.Veenhuijsen wrote:
> What I would do in this case is writing my own little
> parser program to spool it in to a MySQL database.
> I often use Delphi for this.
>
> What is the record delimiter?
The only way that you know a new record starts is the line starts with '-'
('-T&F eBook data rec.1534 @ 27/01/2003').
> OTOP with nothing behind it means emty field?
In fact there are two nword spaces there.
> Execept for the USAU fields it seem all very fieldname/content like.
In this record, that is true but having a look through a sample I have found
at least 5 fields that have 'duplicates'.
I still don't see how it is going to be easy.
George
>
> Jochem
>
>
> George Pitcher wrote:
> > Hi,
> >
> > I'm looking for some advice.
> >
> > One of my suppliers (big publisher) has sent me a file
> containing records of
> > their books. The file is anabsolute nightmare.
> >
> > There are approx 8000 records and the format is like this
> (actual record):
> >
> > -T&F eBook data rec.1534 @ 27/01/2003
> > VISBN 0203445570
> > OSBN 0-203-44557-0
> > EBK1 0203548310
> > EBK2 0203651057
> > EBK3 020375381X
> > EBK4 0203273567
> > OTOP
> > OTART
> > OTI Creative Mathematics
> > OSUB
> > USAU Upitis |f Rena |u Queens University |c Kingston, Ontario |x
> > Canada
> > USAU Phillips |f Eileen |u Teacher |c Vancover |x Canada
> > USAU Higginson |f William |u Queens University |c Kingston |x
> > Canada
> > EDIT
> > INTRO
> > FORWD Pimm |f David |u The Open University x| UK
> > TRANS
> > 2BIND 0415164621 |P 70.00 |U 100.00 |B Hb |A |M 1 |T Creative
> > Mathematics
> > VPR 11.99
> > USPRI 17.99
> > OTBPR 19.99 |U 25.95 |D 17/07/1997
> > USBDG
> > MFDT
> > ERT GB US CA AU NZ ZA IE
> > ORT
> > NRT
> > TTY
> > OBIND eB
> > PDUE 11/03/2002
> > VIZE
> > VEXT 192
> > OILLS 40 illustrations
> > LEVEL
> > OSER
> > OIMP RoutledgeFalmer
> > LIBPR
> > OALT
> > OPPQ
> > OCATL This book shows how creative maths can <I>really</I> work.
> > Exploring the ways in which maths skills can be learned
> > through cross-curricular activities based on visual arts
> > and music, the book presents maths as a meaningful and
> > exciting subject which holds no fears for children.<BR> The
> > authors recognise that while maths-phobia prevails in our
> > increasingly mathematicised world, attitudes and
> > approaches to teaching the subject need to be reviewed,
> > and issues such as gender stereotyping, which encourage
> > maths-apathy, need to be tackled at an early stage.<BR>
> > Within this collection of classroom-based stories are
> > detailed examples of integrative mathematic projects;
> > these will give teachers the confidence to try out
> > cross-curricular activities in their classes. The book
> > also provides support with difficult areas such as
> > assessment, planning and development.<BR> Fascinating to
> > read in its own right this book will appeal to the
> > specialist and non-specialist alike.<BR>
> > OCONC This book shows how creative maths can <I>really</I> work.
> > Exploring the ways in which maths skills can be learned
> > through cross-curricular activities based on visual arts
> > and music, the book presents maths as a meaningful and
> > exciting subject which holds no fears for children.<BR> The
> > authors recognise that while maths-phobia prevails in our
> > increasingly mathematicised world, attitudes and
> > approaches to teaching the subject need to be reviewed,
> > and issues such as gender stereotyping, which encourage
> > maths-apathy, need to be tackled at an early stage.<BR>
> > Within this collection of classroom-based stories are
> > detailed examples of integrative mathematic projects;
> > these will give teachers the confidence to try out
> > cross-curricular activities in their classes. The book
> > also provides support with difficult areas such as
> > assessment, planning and development.<BR> Fascinating to
> > read in its own right this book will appeal to the
> > specialist and non-specialist alike.<BR>
> > OCATS Exploring the ways in which maths skills can be learned
> > through cross-curricular projects on arts and music, this
> > book presents maths as a meaningful and exciting subject
> > which holds no fear for children.
> > OQUO 'This is a fascinating book ... which gives detailed case
> > studies.' |I Infant Equipment
> > OCNT
> > FCONT
> > OWRIT
> > VEDIT 1
> > BICAC U
> > BSUB1 J
> > BSUB2 JD
> > BSUB3
> > BICAV RF
> > SUBJ1 SB150000
> > SUBJ2
> > SUBJ3
> > VPROD EB
> > VACDE WEB
> > CREAT MFK - AUTO |D 2002 07 19
> >
> > So as you see, the filed names are at the left hand side with the data
> > starting at position 6 (5 if the line-start is 0). I usually
> use Excell to
> > clean up this sort of stuff but those fields with a lot of text
> in them just
> > get trashed in the process.
> >
> > I have used Frontier to parse ACARS logs in the past and I
> thought that PHP
> > might be able to help out here.
> >
> > I want to be able to convert the fieldname (where it is duplicated in a
> > record) so that each one is unique. Strip out returns,
> replacing with [tab]
> > and the producing an output file that can be imported into a db (MySQL
> > eventually but I'm using FileMaker right now).
> >
> > Any suggestions (that do not involve a pistol)?
> >
> > George in Oxford
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ===
> >
> > George Pitcher
> > HERON Technical Manager
> > Ingenta plc
> > 23-38 Hythe Bridge Street, Oxford, OX1 2ET
> > T +44 (0)1865 799137 direct
> > T +44 (0)1865 799000 switchboard
> > F +44 (0)1865 799134
> > E [EMAIL PROTECTED]
> >
> > www.ingenta.com
> > Ingenta: Empowering the exchange of academic and professional content
> > online.
> >
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
