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 CreateNewFieldNow 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
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
