We normally export CRs as some kind of unique escape sequence (like "#13" or so) that can be easily replaced by CRs in Excel.
That way the export data can be handled without problems in all systems that allow for global search&replace. Cheers, Tilman ---- extragroup GmbH Pottkamp 19 48149 Münster Germany Mobil: +49 178 721 5210 (Skype: TilmanHaerdle) Fax: +49 251 39089-10 WWW: http://www.extragroup.de Email: [email protected] Geschäftsführer: Lars Busch Registergericht: Amtsgericht Münster / HRB: 5624 Steuer Nr.: 337/5903/0421 - UstID: DE 204607841 Vectorworks interiorcad - profacto Am 15.03.2017 um 19:46 schrieb Chip Scheide via 4D_Tech <[email protected]<mailto:[email protected]>>: I am trying to export some data to tab separated format. it is possible that there are carriage returns in the data. Is there a character (or combination) that I can use to replace the return to get excel to automatically wrap the text into one cell? Thanks --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
