Running into a small... well large problem and hope someone here can help.

I'm exporting my filemaker file to a csv file but that file is formatted for macintosh and I need it formatted for windows.

Any ideas?

excel doesn't help due to it's terrible conversion of fields or text being too large for it to handle if imported as "text."

I guess I'm looking for a program that simply converts mac csv files to windows csv files or a way of doing it in filemaker.

thanks

On the window where you specify the fields you want to export, there should be an option for output character set. Have you tried playing with those options?

dunno if it's the best way but I reopen my exported csv's with textwrangler (http://www.barebones.com/products/textwrangler/) and re-save them with windows linebreaks/character set.

There is a Windows ANSI encoding option. But it has problems with special characters, such as in Mañuel. You export XML, with an XSL stylesheet, and still use Unicode encoding (either 8 or 16). The xsl is a little more complex for comma-delimited than for tab, but it is not bad, and it is generic; it will work with any FileMaker XML export.

<?xml version="1.0" encoding="utf-8"?>



xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm" >





















"



"







,









 



 

Edited August 3, 200718 yr by Guest

This line should have a "?>" at the end. The PHP engine keeps removing it.

<?xml version="1.0" encoding="utf-8"?>