>> 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
---------------------------------------------------------------------
