What are you using to do the export?, 4D export functionality, quick report or something else?
If you are using 4D export, just change the EOL char to something else, the use that char as the line delimiter when you open it in Excel. Another option is to export it in DBF format, then import it to a fresh DB where you can manipulate it any way you wish. If you are using Quick Report and print to file, you can insert a "Replace String" command for each of those text fields and again manipulate it outside of this system. Lahav -----Original Message----- From: 4D_Tech <[email protected]> On Behalf Of Perkins, Bradley D via 4D_Tech Sent: Friday, August 3, 2018 11:22 AM To: [email protected] Cc: Perkins, Bradley D <[email protected]> Subject: Export text columns containing carriage returns to Excel? 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. If I do a straight tab-delimited export with carriage returns as the end of line marker, the imported result does not preserve the original row because any returns encountered in the text fields are interpreted as end of row. My other challenge is that I need to do this with out-of-box end user capabilities from a client (v15.4 remote) against a compiled server. I can't install plugins, create new methods, etc. It has been many years since I've had to do this type of thing in 4D. Can I replace the carriage returns in the text fields with a special marker during export? I could replace the Excel cells containing the any carriage return markers with actual returns after import. Thanks, Brad Perkins ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
