The built-in FileMaker exports are pretty much hardcoded. You can export XML and transform it into text with a XSLT stylesheet; this way you'll have much more control. Do you need some help with XSLT?
Thanks for the fast answer.
I would be glad if you can give me some help with XSLT sheets.
I never worked with that feature.
Here are the files. The first, export_256.xslt will take the first field in the first record and export it as is. This is best if your field is already exactly 256 character long. The second, export_256_with_padding.xslt will do the same, but will explicitly trim the field contents to 256 characters, padding smaller data with trailing spaces.
same link as plain text, if the above doesn't work: http://www.mediafire.com/?e58ap3soprj4l
To use them, export your data as XML and in the export dialog select the appropriate XSLT stylesheet.
Thanks for your help. The scripts work fine :-)
I only added <encoding="ISO-8859-1"> to get the right umlaut.
This works fine for Windows (XP), but do you know which parameter I need for an Intel-MAC (OS 10.5.8)?
E.g.: when I send the Data directly to a file using the Filemaker-Export-function mentioned above, I'll get a file which I can open with the Program "Textedit" and the umlaut is fine. If you look at the binary-file, you see that e.g. the a-umlaut is code 80 (hex).
After using your script (export_256.xslt) and encoding to ISO-8859-1 >>> the a-umlaut for example is coded C4(hex) which is fine for windows, but wrong for my MAC.
I tried to learn it by myself, but so far had no luck :-(
Can you help?
Many thanks in advance!
Mac OS X uses Mac Roman; in XSLT this will be <encoding="macintosh">. But then this file won't open correctly under Windows. So you'd have to have two files, I guess. In Mac OS X Text Edit one can manually specify encoding when opening a file, but this can be tedious.
sometimes it's so easy.... :-)
You only have to have the "magic word" :-)
You are right - I have to use two script files.
But that's no problem, because I simply branch with "Get(SystemPlatform)".
Thank you once more for your help - now everything runs well :-)