Possible to change text in Filemaker field to TitleCase usin Aplscrpt?

Scripting Forums AppleScript | Mac OS X
#1

I’ll start by saying I’m very new to Applescript.
Is it possible to change text in a Filemaker field to Title Case using an AppleScript within Filemaker? I don’t want to export it to TextEdit first or anything like that. I’m trying to change multiple records in a text field “FirstName” to title case for a filemaker to photoshop action. Much of the data was entered by hand and not corrected so it looks like “joHn” & “jOHN” instead of “John”. Any suggestions would be great. I hope this makes sense.
Thanks,
-RM34

AppleScript: 1.10.7
Browser: Firefox 3.0.1
Operating System: Mac OS X (10.4)

#2

I cannot give you any advice about the FileMaker part (I don’t have this app installed on my private Mac), but you can easily title names with code like follows:


set input to "joHn mACinTOSH"
set output to do shell script "python -c 'print u\"" & input & "\".title()'"

Please note that it is slightly different if you need to process names containing special chars (like German Umlauts).

#3

Martin,
Thank you for the quick reply.
I figured out how to resolve the problem within filemaker itself.
-RM34