I'm trying to use Export Records on a single record to export a single field containing XML code. The file needs to be in UTF-8 format, which is why I'm using Export Records instead of Export Field Contents. I'm exporting as a Tab separated file.

The problem I'm having is that the resulting XML code is malformed because the carriage returns are stripped out and there is one single line.

Is there a way force FileMaker to keep the carriage returns so the code is correct?

When I use Export Field Contents the code is unchanged.

Thanks

I am afraid it's one or the other (UTF-8 or returns). If you want to export your data as XML, you can use the built-in XML export format.

...

The problem I'm having is that the resulting XML code is malformed because the carriage returns are stripped out and there is one single line.

Is there a way force FileMaker to keep the carriage returns so the code is correct?

Actually the carriage returns aren't stripped out. They are converted to "vertical tab" characters. Either way you have grief since it isn't working as you would like.

Since XML doesn't necessarily need carriage returns at all to be valid, you might try simply removing all returns in your source text and making a single-line XML file. This would only be a viable option if the data you are encoding in the XML itself has no line breaks and if you don't need your XML output to be friendly human-readable.

XML export is the best way to go, but you do have another option to export using tab-delimited and have multi-line output. That would be to put each line of your XML text in a separate record in a table. (It is easiest to create a new table specifically for this export feature.) Export the one field from this table as tab-delimited.

Removing carriage returns beforehand might be a good way around the problem. The ultimate goal is automation so I don't care if the files are human readable. I'll try this out.