RR and FileMaker

Jim Hurley jhurley at infostations.com
Wed Apr 2 19:23:01 EST 2003

>>  The recent discussion on interfacing FileMaker and Rev has aroused my
>>  curiosity.
>>  I have occasion, especially at election time, to work with FileMaker.
>>  Since I  have never been able to decipher the arcane scripting
>>  language in FileMaker, my alternative has been to export the
>>  FileMaker file as a text file, make my changes using Transcript in RR
>>  and then import the altered text file back into FileMaker.
>>  Can I assume that this is not a really dumb way to work with FileMaker?
>No,  I would not assume that. What exactly are you trying to do?


Here is an example. Say I have a field which has something like the following:

stuff, stuff, AP# 103-837-47, more stuff, more stuff

Were AP# might be a county parcel number. The 837 might be a county 
tax zone. And I might want to extract  that 837 and make it  a 
separate field. In Transcript I just write:

on CreateNewField
   put field 1 into tRecords
   repeat for each line tLine in tRecords
     set the itemdelimiter to comma
     put item 3 of tLine into temp
     Set  itemdelimiter to "-"
     put comma & item 2 of  tLine after tLine
     put tLine & return after results
   end repeat
   put results into field 1
end CreateNewField

Now I'm sure this can be done as well within FileMaker, but  I have a 
deep seated aversion to the  scripting language in FileMaker.

As I said, I first have  to  save the file as text, do my Transcript 
thing, and then import it back into FileMaker. Tedious but, for me, 
better than working in FileMaker.


More information about the use-livecode mailing list