Thanks - I'll try that too
On Wed, 28 Nov 2018 08:30:01 +0000, Epperlein, Lutz (agendo) via 4D_Tech wrote: > You have to escape the data cell containing the linefeed with double > quotes. The linefeed has to be encoded as a LF (0x0a) or as CRLF > (0x0d 0x0a). > > E.g. > Data <tab> data <tab> data <crlf> > data <tab> data <tab> "line1 <lf> > line2"<crlf> > data <tab> data <tab> data<crlf> > > This text file you can drag onto Excel to open it (Windows). > Double click on Windows Explorer doesn't work since it is a .txt file. > > Better is to save it as a .csv file and use a semicolon ";" instead > of a tab. So you can use double click to open it (again on Windows). > > Regards > Lutz > >> -----Original Message----- >> From: 4D_Tech [mailto:[email protected]] On Behalf Of >> Chip Scheide via >> 4D_Tech >> Sent: Tuesday, November 27, 2018 11:08 PM >> To: 4D iNug Technical <[email protected]> >> Cc: Chip Scheide <[email protected]> >> Subject: v13 - Exporting tab delimited >> >> I would like to be able to embed a return and/or line feed into column >> in a tab delimited file (opening with Excel). >> >> ex: >> data <tab> data <tab> text data with return more data <tab> data >> <return> >> >> Excel will give me: >> Col1 Col2 Col3 >> Data Data text data with >> more data data >> >> >> I can not see a way to do this. >> Is it possible? >> if so, how? >> >> Thanks >> Chip >> --------------- >> Gas is for washing parts >> Alcohol is for drinkin' >> Nitromethane is for racing >> ********************************************************************* >> * >> 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] > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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] **********************************************************************
