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:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide > via > 4D_Tech > Sent: Tuesday, November 27, 2018 11:08 PM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Chip Scheide <4d_o...@pghrepository.org> > 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************* > * ********************************************************************** 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 **********************************************************************