RR and FileMaker
jhurley at infostations.com
Wed Apr 2 19:23:01 EST 2003
>> The recent discussion on interfacing FileMaker and Rev has aroused my
>> 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:
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
put results into field 1
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