Hi 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.
Thanks, Brad ________________________________ From: Keith Goebel <keit...@orcon.net.nz> Sent: Saturday, August 4, 2018 7:58:56 PM To: 4D Tech Mailing List Technical Cc: Perkins, Bradley D Subject: Re: Export text columns containing carriage returns to Excel? Brad, 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... Excel can open a csv file using a double-click without problems (for me anyway), although I haven’t found a way to create page tabbed spreadsheets or pre-formatted cells, but you can embed some “commands” in the exported data (Sum, etc). HTH, Keith > I've been asked to provide an export from a legacy 4D system delivered as an > .xlsx file. > > The challenge I'm facing is that this table contains a number of text fields > and the customer requires the imported column cells to retain the returns or > line feeds in the original text fields…. ********************************************************************** 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 **********************************************************************
