Re: pulling data out

Yeah, that's ugly. RJS software's converter makes you find unique
identifiers for each record 'type'. That's all any of these can do. Things
like a decimal point in a certain position, with numbers in certain blocks,
or blanks in certain places, all connected with ANDs and ORs. Not a lot of
fun, but usually doable.

Here you have an CITY field, a STATE field, a NAME field, etc., in the
first 2 lines. That structure, which must repeat sowmshat, can be parsed
into fields that you arrange as you will. It CAN be done, usually, if
there's any repeatability at all.

Monarch probably is similar. These products are pretty well thought out and
powerful.

At 12:05 PM 8/8/02 -0700, you wrote:
>--
>
>
>Bman9111@collegeclub.com wrote:
>
> >The problem is that mapics gathers data from certain tables the spool
> file looks kind of like this:
> >
> >001       Tom johns          12324      23.02
> >    510 long ave         ny
> >   001     23.02
> >   001    -23.02     23.02
> >You see I have to be able to grab each title and place it into fields.
> >and the formating is always different so I can't every estimate on line
> numbers per records.
> >
>jon