Keith, I asked because I haven't seen that feature. I mostly work with non-4D systems these days and some have that capability. Also, I'd like to not have to install code, a component etc as I'm trying to do the export from their production compiled database.
It is looking like I can probably get 90% of where I need to be with QRs and using Replace string to mark the crlf, cr and tab occurrences. I'll then need to open the exported file in a text editor that can handle large files and ensure that the file will be importable into Excel. Best, Brad ________________________________ From: Keith Goebel <keit...@orcon.net.nz> Sent: Sunday, August 5, 2018 2:53 PM To: 4D Tech Mailing List Technical; Perkins, Bradley D Subject: Re: Export text columns containing carriage returns to Excel? Brad, I don’t know - I rarely use 4D’s export and when I do it’s only for a quick text file (tab delimited) export. I do my main exports using code and the csv version follows the cvs rules and it works great. Sorry I can’t share the code - it is buried in a contracted project. I suspect there are some 4Ders that have csv export code at their fingertips (or in a component) that may chip in here… Cheers, Keith Is there an explicit CSV option in Export Data or Quick Reports that will properly 'quote' and escape any commas (or tabs, unfortunately there are a few) in the exported text fields? If 4D can produce a file that I don't have to inspect and manipulate prior to importing into Excel that would be wonderful. There have been a couple of “export data” related threads lately that seem to be having problems with embedded CRs. Where I have CRs in the data, I save the exported data as csv and that has always solved that problem for me. Perhaps there is some reason that is not suitable for you... ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
