Chip: Unless you must use tabs, what about CSV? I think that was a big reason why the CSV "standard" created.
-- Douglas von Roeder 949-336-2902 On Tue, Nov 27, 2018 at 4:10 PM Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Chip, > > Character code for a Soft Return is 11 > > Randy Engle > > -----Original Message----- > From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip Scheide > via 4D_Tech > Sent: Tuesday, November 27, 2018 3:51 PM > To: benedic...@comcast.net > Cc: Chip Scheide <4d_o...@pghrepository.org>; 4d_tech@lists.4d.com > Subject: Re: v13 - Exporting tab delimited > > 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 > ********************************************************************** > > ********************************************************************** > 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 **********************************************************************