Exporting carriage returns in a multi-key field

[bongoman]

Hi there

 

I need to import a csv file from a Filemaker solution into MySQL. The Filemaker developer has used a multikey field with values seperated by carriage returns.

 

However, when I export from FMP to a csv file, none of the character returns are present - all the values are joined as one, which renders it impossible to then parse with my server-side code (Ruby)

 

I was hoping to convert the multikey string into an array in Ruby so that I can then have access to the keys contained therein.

 

Any clues on how to export a multikey field into csv so that I can access the individual keys?

[comment]

When you export as csv or tab, carriage return characters in a field are exported as vertical tab characters (ASCII 11).

[aaa]

Hi, bongoman!

May be this help?

Create Calc_Field=Substitute ( MultiKey;"¶";" " ) and instead MultiKey export Calc_Field.

[bongoman]

Thanks everyone - and does it matter what character encoding I export as? MacRoman, ISO, UTF, etc?