AppleScript issue with returns in database (FMP) fields

[Daniel Wenger]

Thank you Ken Ray and Flexible.

Found the problem. FMP uses numtochar(13) to separate lines in a  
field. AppleScript Script Editor for some reason converts these to  
returns, just to confuse people like me. They do not show up in the  
Revolution field even as a funny character, just missing. Conversion  
to returns solves the problem.

Daniel Wenger

On Aug 11, 2005, at 11:08 AM, FlexibleLearning at aol.com wrote:




> On 8/11/05 7:53 AM, "Daniel Wenger"  
> <DanielWenger at worldnet.att.net>  wrote:
>
>
>
>
>
>> I have an AppleScript script in a Revolution stack. The  script, when
>> tested via the (AppleScript) Script Editor, gets records  from a File
>> Maker Pro (ver. 5) database without problem. Some fields in  the FMP
>> database have returns separating lines of text. The Script  Editor
>> brings the returns into the result with no problem.
>>
>> When the script is executed in Revolution via a "do as  AppleScript"
>> command the result returns the information from the FMP  fields with
>> the return chars missing. All lines from within the FMP  field are
>> joined together.
>>
>> Any ideas as to how to fix  this?
>>
>>
>>
>>
>
> If memory serves, FMP (like MSWord cells) uses numtochar(11) or a   
> vertical
> tab for CR and numtochar(9) or a horizontal tab for TAB. When you   
> import the
> data, use "replace numtochar(11) with CR in tData" and "replace   
> numtochar(9)
> with TAB in tData" to re-instate the formatting.
>
> /H
> The  Flexible Learning Company
> Home of The Scripter's Scrapbook
> www.FlexibleLearning.com/ssbk.htm
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>
>