I spent many hours sorting this out a few months ago. The file needed to be easily read by Excel (as in your case) plus it needed to be importable into SQL Server. I ended up creating a CSV with CRLF record delimiters. But I also processed the embedded soft returns in a way that escapes me right now. I'll try to look that code up tomorrow, if it still exists.
Once you have a .csv, it can be double-clicked to open in Excel avoiding the Import Wizard entirely. BTW, the difficulty here is all due to Excel's bizarre and unique way of handling things. I'll see whether I can shed any light on this tomorrow. Tom > On November 27, 2018 at 3:50 PM Chip Scheide <4d_o...@pghrepository.org> > wrote: > > > Thomas & Chuck > the intent is to create the export file in such a manner that NO user > intervention is required to open the file with the embedded returns. > > changing the end of row marker will work, but then the user(s) need to know > that -- and they won't or they won't remember etc -- after all they are > users.... > > typing Alt-return is not really an option s the data is already exported... > The embedded character is listed as &Char(10)& for line feed, and &Char(13)& > for carriage return, however, replacing the return (4D) with either or both > of these strings does NOT result in return or line feed in Excel; just the > exact characters "&Char(10)&" > A bit of experimentation shows that to get the character code to work > requires a formal where for example you have > =A1+&Char(10)&+B3 > > any other ideas?? > > Thanks > > > Hi Chip, > > > > The trick with Excel is that it uses a 'soft return' within a cell. > > To get that soft-return within Excel you type Alt-Return (on Windows) > > or Control-Option-Return (on MacOS). > > > > I don't remember what the Character Code is for that character, but > > that's what you'll need to include in your extract script. I seem to > > recall that it is a newline. Google should be able to help you. > > > > Hope this helps, and sorry it doesn't have more details. > > > > Tom Benedict > > Optum > > > >> On November 27, 2018 at 2:07 PM Chip Scheide via 4D_Tech > >> <4d_tech@lists.4d.com> wrote: > >> > >> > >> I would like to be able to embed a return and/or line feed into column > >> in a tab delimited file (opening with Excel). > >> > > > ------------ > Hell is other people > Jean-Paul Sartre ********************************************************************** 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 **********************************************************************