Export Field Contents as UTF8?

[Macfreq]

I have a global field that I'm trying to export into a file using Export Field Contents but FileMaker is creating a UTF16 encoded file. I need a UTF8 encoded file. Is there a system or FileMaker setting somewhere that can change this default?

I'm on a Mac running 10.6

Thanks,

[comment]

No, it's always UTF-16. See here for some alternatives:

http://fmforums.com/forum/showtopic.php?tid/183607/post/235940/#235940

[Macfreq]

The applescript looks promising but I haven't ran an applescript from within FileMaker before. For the following code, how do I export a global field called g_field to a file called text.txt? I'm not sure where to put the actual field and filename.

copy cell "filename" of current record to fileName

copy cell "Text_" of current record to exportMe

do shell script "echo -n " & quoted form of exportMe & " > ~/desktop/" & quoted form of fileName

[comment]

I believe that could be done by:

copy cell "g_field" of current record to myText

do shell script "echo -n " & quoted form of myText & " > ~/desktop/text.txt"

[TheTominator]

copy cell "g_field" of current record to myText

do shell script "echo -n " & quoted form of myText & " > ~/desktop/text.txt"

A FileMaker script variation that requires less AppleScript is...

Copy[select; YourTable::g_field]

Perform AppleScript["do shell script "pbpaste > ~/desktop/text.txt""]

The downside is that you do need to perform this on a layout that contains the field.