3 Replies Latest reply on Jul 30, 2013 1:02 PM by disabled_ntaylor

    Exporting special characters yields other odd characters

    HP

      Summary

      Exporting special characters yields other odd characters

      Product

      FileMaker Pro

      Version

      Filemaker Pro Advanced 12.0.v4

      Operating system version

      Windows 7

      Description of the issue

      When exported, special characters with accents, such as é (e with accent), are transformed into different accented characters like Ž (Z with a caron accent mark). Sometimes the accented characters will just not be exported at all (ex: resumé becomes resum )

      Steps to reproduce the problem

      Have data with accented characters. Export the data to a TSV.

      Expected result

      Original accented characters

      Actual result

      Odd accented characters

        • 1. Re: Exporting special characters yields other odd characters

               H P:

               Thank you for the post.

                

               FileMaker does not include font information when exporting to a text file, so the special font will be lost.

                

               For more information and a couple suggested workarounds see Knowledge Base article 5097, Exporting Special Font Characters.

                

               TSFalcon

               FileMaker, Inc.

          • 2. Re: Exporting special characters yields other odd characters
            HP

                 EDIT: It seems like my problem has to do with a charset mismatch. Thanks!

            • 3. Re: Exporting special characters yields other odd characters

                    

                   H P:

                    

                   Thank you for the reply.

                    

                   By reading in special characters do you mean importing? 

                    

                   FileMaker serves as a translator or decoder for the numbers behind the letters. To FileMaker the font characters are nothing more than numbers. Different programs and even different operating systems use the same numbers for multiple characters. Macintosh, ASCII, and Windows all use different character sets.

                    

                   You can use the Code function to decode the number behind the letter. For example, I did a simple test with the following letters: 

                    

                   é 

                   Ç 

                   È

                    

                   I created 3 records in a text field with those 3 characters. I exported to .csv, and then imported back into the database file, adding new records. I also, created a calculation field using Code ( special char field ) to check the numbered results. The exported characters were identical to the imported characters. See the screenshot below.

                    

                   TSFalcon

                   FileMaker, Inc.