Re: Converting FileMaker Pro 4.1 files from Mac to AS/400

[Rob Dixon <rob.dixon@xxxxxxxxxxx>]

Dave


> I have converted comma delimited filemaker pro files and had to write a few
> programs to go through the data and parse it out.  Part of the problem was a
> few "free" form fields that people just keyed in anything they wanted which
> included special characters and a host of other things.

So that is what it is.  I could not work out any consistency from a visual scan
of the records.

> I tried a bunch of
> different ways to get the incoming data to look consistent but in the long
> run I ended up creating a flag field in the existing data (byte 1) that I
> set if I just couldn't figure the data out and had the users manually key
> the correct information via green screen.  If you want I could give you the
> programs I used...

That most generous offer is gratefully accepted.  I assume that they are not too
large for e-mail, but if they are, the post would do.

Best wishes

Rob Dixon

________________________________________________________

Erros plc

44 (0) 1844 239 339

http://www.erros.co.uk/ERROSHOME/erros_home.htm - The AS/400 Neural Database for
the Internet

_________________________________________________________

begin:vcard 
n:Dixon;Rob
tel;fax:44 1844 239340
tel;work:44 1844 239339
x-mozilla-html:TRUE
org:Erros plc
version:2.1
email;internet:rob.dixon@erros.co.uk
title:Chairman
adr;quoted-printable:;;Boarstall Tower=0D=0ABoarstall;;Bucks;HP18 9UX;United Kingdom
fn:Rob Dixon
end:vcard