.csv problem

[acantho]

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

[mr_vodka]

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?

[tom duckers]

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.

[Fenton]

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, 2007 by Guest

[Fenton]

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

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