Or you could do it in one file.
Make 5 fields, one text field (OrigLabel) which will contain the entire original text
(and you would import into this field only.)
Then 5 other fields (Name, Address, City, State, Zip) would be calcs that would
separate out and grab the data from OrigLabel. (Or you could make them text fields
and do the calcs via script. Either way works.) Then you would just import those 5
fields into ebase.
If you need help with the calcs themselves, let me know, but basically you would be
splitting the field first by newline characters (the Paragraph symbol in FMP) and then
by commas and spaces in the third line.
Matt
At 08:43 AM 4/23/01 -0400, you wrote:
>
>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
>---------------------------------------------------------------------
>
>
Matthew Scholtz
Database and Non-Profit Technology Consultant
Bellingham, WA
Also associated with NPower, Seattle
www.npower.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
---------------------------------------------------------------------
