You should be able to do it in ScriptMaker. Import into a file with one text
field. You can read files record by record, so read four records, write into
another file in spread fields, repeat until done.
> -----Original Message-----
> From: Colin Cooler [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 12:16 AM
> To: TechRocks Support
> Subject: [support] RE: Converting scanned mailing labels
>
>
>
> >> I have some mailing labels which I have scanned and converted to
> >> ASCII data
> >> via OCR. Now I need to get this info into a FMP5 (Mac)
> database and then
> >> into ebase. The problem is that each LINE of the data is treated as a
> >> single record when I try to import into my FMP database, instead
> >> of a group
> >> of three lines equaling ONE record. Furthermore, the third line
> >> would have
> >> three fields (city, state, zip).
> >>
> >> Can someone suggest a way that I can convert this data into
> one five-field
> >> record for each mailing label. (I feel like I'm missing
> >> something obvious)
> >>
> > What you should do is highly dependent on the data.
> >
> > 1) When we swap mailing lists with other organizations we give
> them printed
> > labels so that it is hard for them to add them to their
> database. In other
> > words do you have permission to reuse the data on the labels?
> Yes, we do!
> >
> > 2) How many records are there? I would do different things for
> 100 than for
> > 10,000. For 100 I might just cut and paste. For 10,000 I would write a
> > program (see below).
> There are 600-700 records.
>
> > 3) How regular are the records, i.e. all exactly 3 lines, all have comma
> > after city, etc. When I OCR stuff, commas are frequently recognized as
> > periods. Are there blank lines between entries? If too many
> irregularities,
> > writing a program is hard.
> The data is consistent. All are exactly 3 lines and have commas after the
> city. There are blank lines between each set of 3 lines.
> >
> > 4) One of the programs on my system knows how to handle
> multiline records,
> > but a quick search did not turn it up. I thought it was
> WordPerfect but I
> > couldn't find it. It may have only been in older versions.
> I have Wordperfect 3.5, if this makes a difference!
>
> Thanks, Walt, for any further help you can suggest. I'm getting a little
> desperate....I have to have this done this week. Would a FMP Scriptmaker
> script be able to convert/consolidate multiple "records" into a single
> record?? I'm stumped.
>
> Colin
>
>
> ------------------
> Reminder to each recipient: To change your list account preferences, go to
> http://email.sparklist.com/scripts/lyris.pl?enter=support and
> enter the email address you used to subscribe to the ebase
> support list:: [EMAIL PROTECTED]
>
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
> ---------------------------------------------------------------------
>
>
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
