>
> 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?
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).
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.
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.
------------------
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
---------------------------------------------------------------------
