When exporting as CSV, FileMaker (properly) changes in-field carriage returns to ASCII 11 (VT, vertical tab?). So, if want something else, like a pipe "|" or something, you'd need to create a calculation field which used Substitute ( the field; ¶; "|").
This is going to post to an online sql database, and must appear correctly. Can you tell me what the char for this is: 0x2029 PARAGRAPH SEPARATOR
On a Mac; when I look at it in BBEdit, it says: \x0B
In the Characters palette it's listed as:
So what would that be as Char()?
Is there a list somewhere which shows which Unicode characters translate to Char() numbers.
It would be Char (11), at least that's what FileMaker Exports as CSV, which is the same as ASCII for these lower characters.
But FileMaker shows it and works with it internally as an old style Mac carriage return, Char (13).* So, if you wanted to change the internal FileMaker "returns in a field" to something else, that is what you'd change.
* Char(13) is the same as this older FileMaker symbol (requires quotes if multiple): ¶
P.S. I don't really know why I was telling you that it was Char(11) earlier. That is what FileMaker Exports. So you might want to know that to post-process an exported text file. I think other applications, such as Excel, handle this much the same.
But if you just want to change the separator yourself, pre-export, then you can swap out the ¶ for whatever else you want. Not sure what any other application processing the CSV would think about that.
If all you want is something that looks like a CSV but still has carriage returns (within text within quotes), then that can be done with an Export XML, and a generic XSL stylesheet.
It looks like my server is in fact choking on the FMP export format. Can you step me through the XML thing?
It's asking for either a file or http request. I have no idea what to enter.
You'd need a specific XSL stylesheet to "transform" the FileMaker XMLRESULT (xml) syntax into CSV (text). This file does that:
It has a linefeed within the quoted text for the Name field, and a linefeed (not within quotes) for the line ending.
I named it "Voth" to credit Beverly Voth, who came up with the concat() xml function, to add the quotes. It's just shorter to do it that way.
FileMaker does change carriage returns to vertical tabs (0x0B) but that is nowhere in the RFC for the CSV format (rfc4180) that I could find. The standard way is to simply include the carriage return and make sure the field is surrounded by double-quotation marks.