RR and FileMaker

[Jim Hurley]

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

Bruce,

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.

Jim