Hmmm, don't know what those embedded macros look like when pasted into a field in FileMaker so that makes it hard to suggest anything. One general purpose problem solver for fields that receive pasted text is to add this auto-enter calculation:
textformatRemove ( self )
and then you clear the "do not replace existing value..." checkbox.
But I have no idea if this will make any difference or not in this particular case.
as to newer versions, you could down load the 30 day trial version of Filemaker 12 and test it to see if it has the same issue, but 12 changes your file format so you'd need to convert a copy of your current DB (or create a small test file from scratch) in order to test this.
You have noticed the far right icon in Post a Answer? "Paste from Word"
This should be implemented on the website, and the users trained to use it.
From a word processing document
When cutting and pasting from a document that was created using a word processing program, the software may
insert invisible characters that may not allow the information to be successfully saved.
Note: To avoid this problem, you should cut and paste only text into the CV and introduction letter fields in the
To paste from Microsoft Word
1. Open your document in Microsoft Word and click File in the menu bar.
2. Select Save As.
3. In the "Save as type" field, select Text only with Line Breaks (*.txt).
4. Save the text document to a location where it can easily be found.
5. Close Word.
6. Using Notepad or WordPad, open the new text document.
7. Correct the format of your new document by adding spaces to
align fields or by adding asterisks to denote bulleted items.
8. Select Edit and then Select All to select all of the text.
9. Select Edit and then Copy to copy the text to the clipboard.
10. Paste the text into the appropriate field on the online application by pressing Ctrl and V at the same time.
Posted by admin | Under HTMLWednesday Jun 15, 2011
Many users without computer knowledge copy contents from a word document, and paste them into a HTML form (<textarea></textarea>) and expect to retain formating as well as special characters such as smart quotes and emdashes. You may opt to translate smart quotes to regular quotes and emdashes to regular dashes with a PHP script. If any user submits a non-ASCII character contents, you’ll probably see weird characters in the database and HTML page. Finding and fixing just a few of them (curly quotes and em dashes) isn’t going to solve the real problem.
How do you go about resolving this problem? One way to solve the problem is by educating the users to convert the special characters into ASCII text and submit them into the form. To convert special characters, you may use any of the following methods.
1. Save the word document as a HTML document. Microsoft Word has an option to save .DOC document into a .HTML file. Select the contents from the HTML document, and paste them into the HTML form.
2. Copy the Word contents, and paste them into a notepad; then select the same contents from the notepad, copy and paste them into the HTML form.