Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7850 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Using version 5.5v1 (Mac), when exporting data created using Option-Shift, those characters do not export correctly. Anyone know a fix?

Posted

which character? some are reserved as record/repeat separator.

The Characters involved are:

ASCII 09, 10, 11,13, 29

All others export/import correctly.

Posted

what exactly are you seeing?

they all export correctly. just try to re-import them - they are identical. However, if you move the export to another platform or format them in another font, you will see different characters - but the ascii values remain the same.

Posted

Is there a way to export on the Mac to maintain the correct ASCII code on other platforms? If you enter ASCII code 174 on a Mac, is the result

Posted

Yes the characters above 128 are totally different between Mac and Windows. I don't know whether Filemaker is smart enough to automatically translate these characters when you move a native Filemaker file from Filemaker Mac to Filemaker Windows. Is this what you tried when you say you got the same results on Filemaker Windows version? If so, you may have to go searching for some shareware translation utility. You could probably come up with some translation script in Filemaker too if you know all the character codes on both systems.

Posted

FileMaker Windows will let you choose the character set during text import (csv, tab-delimited, merge). Simply choose "Mac". You cannot specify this on the Mac while exporting, but you can use "Cyclone" or "TEC OSAX" to convert between charsets via AppleScript. (try google search on those keywords + "AppleScript")

You can always export as FileMaker file to maintain charsets when exporting for another platform. SYLK and DBF will get the charset right, but may chop off some chars in your field names + format numbers with a lot of trailing zeros. [1 -> 1.00000000000].

You can also ftp the file with the TEXT, not BINARY, option, so charsets (and line endings) will be converted.

This topic is 7850 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.