Exporting Checkbox gives strange separator character

[rjay]

If I export data that includes a Checkbox or Radio Button, where one or more values have been selected for that field, I get a very strange separator character between each value. It won't even paste here, but it looks like an arrow pointing upwards. I've never seen a character like it and it's not recognised by any program I've tried importing to.

Can we change the separator character used on export ?

[Russell Barlow]

If I export data that includes a Checkbox or Radio Button, where one or more values have been selected for that field, I get a very strange separator character between each value. It won't even paste here, but it looks like an arrow pointing upwards. I've never seen a character like it and it's not recognised by any program I've tried importing to.

Can you update your user profile to list your platform and version of software?

What format are you exporting to and then what is being used to open the exported copy?

Screen shot of what your seeing would be helpful as well. I am pretty sure it should be a EOL.

[rjay]

Attached is what I am seeing. I've opened in Notepad and also my favourite text editor WinSyntax.

I've exported as CSV and MER: same in both.

[Wim Decorte]

I believe the character is a vertical tab. Since the values are return delimited in FM itself those returns have to be transformed to something else or it would break the CSV /TAB format where the return signals the end of a record.

[comment]

If I export data that includes a Checkbox or Radio Button, where one or more values have been selected for that field, I get a very strange separator character between each value.

Multiple values in a field formatted as checkbox or radio button set are separated by a carriage return. When exporting as CSV or Merge, carriage returns in fields are replaced by vertical tab characters:

http://www.filemaker...25.html#1041694