[P1] OT: Fixed field length database files

[Signhelpers]

Thanks for the suggestion. It begins to sound familiar now.

What sort of signs are you interested in?


>On Saturday, March 8, 2003, at 04:27  PM, Signhelpers wrote:
>
>>A little OT, but I'd like some input on converting some fixed field 
>>length record data files to something useable in Filemaker Pro on 
>>my iBook. (Back on topic?)
>>
>>Eons ago a database program I used called Panorama had ways to 
>>convert these to tab-delimited records that could be handled  by 
>>modern database systems. I don't see this function in FM Pro. Am I 
>>mission something? Any suggestions?
>
>Import each record into a record. Then use a calculated field for 
>each fixed length field. Use the Midstring function in the 
>calculation. Something like, and I am not looking up the syntax,
>
>cField1: midstring(fullstring,1,6)
>cField2: midstring(fullstring,7,10)
>cField3: midstring(fullstring, 11,3)
>
>Trade some sinage for a working file?
>
>---
>
>Boycott French Kissing
>
>jackrodgers at earthlink.net
>http://www.jackrodgers.com
>
>
>----------
>iBookList, a listserv for users and fans of Apple's iBook.
>FAQ at <http://www.themacintoshguy.com/lists/iBookListFAQ.shtml>
>
>To unsubscribe, E-mail to: <ibook-off at lists.themacintoshguy.com>
>To switch to the DIGEST mode, E-mail to 
><ibook-digest at lists.themacintoshguy.com>
>Need help from a real person? Try.  <ibook-request at lists.themacintoshguy.com>
>----------
>Small Dog Electronics    http://www.smalldog.com   | Enter To Win A |
>  --  Canon Digital Camcorders start at $799       |  Free iBook!   |
>
>iBookPlanet.com |  Visit iBookPlanet.com for the hottest
>                |  iBook News, Features, Reviews & More.
>
>   RoadTools $30 PodiumPad available at Apple retail stores, $20 
>Traveler  CoolPad at Staples. Both in white for iBooks at 
><http://roadtools.com>
>
>MacResQ Specials: LaCie SCSI CDR From $99! PowerBook 3400/200 Only 
>$879! Norton AntiVirus 6 Only $19! We Stock PARTS! 
><http://www.macresq.com>


-- 
Signhelpers - One stop for all your sign needs.
Mike Urseth
Signhelpers
P.O. Box 237
Ridgeland WI  54763
715-837-1120