In my excel version a tab delimited file as long as the field has DoubleQuotes, then the tab delimited file can contain a LineFeed hex:0A in that field Then it will not cause a row break, it will instead contain a new line within the cell.
If you don’t have the double quotes then excel will treat the LineFeed as a new row Regards Aaron > On Mar 15, 2017, at 5:12 PM, [email protected] wrote: > > Send 4D_Tech mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.4d.com/mailman/listinfo/4d_tech > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of 4D_Tech digest..." > > > Today's Topics: > > 1. Re: tab seperated text - what to use for Cr (Arnaud de Montard) > 2. Re: tab seperated text - what to use for Cr (Chip Scheide) > 3. Re: tab seperated text - what to use for Cr (Tim Nevels) > 4. Re: tab seperated text - what to use for Cr (Tilman Haerdle) > 5. Weird variable (non-)refresh issue ([email protected]) > 6. Re: Weird variable (non-)refresh issue (Jim Dorrance) > 7. Re: tab seperated text - what to use for Cr (Keisuke Miyako) > 8. Re: Weird variable (non-)refresh issue (Keisuke Miyako) > 9. Re: Unique Files Verification Software (Bruno LEGAY) > 10. Larry Sharpe (Lee Hinde) > 11. RE: Larry Sharpe (Randy Engle) > 12. Re: Larry Sharpe (Tom Dillon) > 13. Re: Larry Sharpe (Douglas von Roeder) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 15 Mar 2017 20:15:34 +0100 > From: Arnaud de Montard <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Re: tab seperated text - what to use for Cr > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8 > > >> Le 15 mars 2017 à 19:46, Chip Scheide via 4D_Tech <[email protected]> a >> écrit : >> >> 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? > > linefeed (char10)? > > -- > Arnaud de Montard > > > > > > ------------------------------ > > Message: 2 > Date: Wed, 15 Mar 2017 15:31:50 -0400 > From: Chip Scheide <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Re: tab seperated text - what to use for Cr > Message-ID: <[email protected]> > Content-Type: text/plain; charset=iso-8859-1 > > I tried that - > it too creates a new row in excel when opened/imported. > > On Wed, 15 Mar 2017 20:15:34 +0100, Arnaud de Montard via 4D_Tech wrote: >> >>> Le 15 mars 2017 à 19:46, Chip Scheide via 4D_Tech >>> <[email protected]> a écrit : >>> >>> 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? >> >> linefeed (char10)? >> >> -- >> Arnaud de Montard >> >> >> >> ********************************************************************** >> 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] >> ********************************************************************** > --------------- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > > > ------------------------------ > > Message: 3 > Date: Wed, 15 Mar 2017 14:38:43 -0500 > From: Tim Nevels <[email protected]> > To: [email protected] > Subject: Re: tab seperated text - what to use for Cr > Message-ID: <[email protected]> > Content-Type: text/plain; charset=utf-8 > > On Mar 15, 2017, at 2:00 PM,Chip Scheide wrote: > >> 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? > > “Space" will work and had no cross-platform macOS/Windows Excel issues. I do > this whenever > > You might also try option-space if you are on macOS. That used to represent a > “hard space” that some Mac software would recognize and treat like a “soft > return”. You would have to do some testing to verify how current versions of > Excel handle this and how it is handled on Windows. > > On Windows Excel will handle alt-Enter as a special line break character. But > I believe this is just a LF — line feed, char(10) — character so it may be > problematic since end of record delimiters are typically CR+LF. > > Tim > > ******************************************** > Tim Nevels > Innovative Solutions > 785-749-3444 > [email protected] > ******************************************** > > > > ------------------------------ > > Message: 4 > Date: Wed, 15 Mar 2017 19:51:24 +0000 > From: Tilman Haerdle <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Re: tab seperated text - what to use for Cr > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > 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] > ********************************************************************** > > > ------------------------------ > > Message: 5 > Date: Wed, 15 Mar 2017 15:56:16 -0400 > From: [email protected] > To: [email protected] > Subject: Weird variable (non-)refresh issue > Message-ID: > <off7648074.ce141680-on852580e4.006cbb91-852580e4.006d8...@parker.com> > Content-Type: text/plain; charset="US-ASCII" > > Hi Everyone, > > I have a situation where I have a variable on an input form that I set > programmatically immediately before opening a dialog window (using the > "Plain Window" window type). When I move the dialog to the side (to see > the input form, now in the background), the variable still has its "old" > value. > > I know the variable is being set because I tried setting the variable > value to the clipboard before opening the dialog (the new value gets > there). When the dialog is closed, the variable is updated with the new > value. > > I've tried throwing in a REDRAW(variablename) and even a DELAY > PROCESS(Current process;60) - but neither has any effect. > > I noticed that the same effect happens even when an ALERT is called > instead of opening a dialog - the variable does not display its new value > in the background. All of this is in the same process, of course. I've > tried using process variable displayed on the form as well as an object > without a variable name (using Object Get Pointer to set the value) - same > results. > > It is important that the screen properly show the "new" value in the input > form so it is visible in the background when the dialog is open. > > Any thoughts? Anyone seen this? How to get a window to refresh before > opening another window? I was quite surprised that even the Delay Process > didn't do it.... > > Many thanks! > > > Bob Miller > Chomerics, a division of Parker Hannifin Corporation > > > > > > > ------------------------------ > > Message: 6 > Date: Wed, 15 Mar 2017 21:00:42 +0100 > From: Jim Dorrance <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Re: Weird variable (non-)refresh issue > Message-ID: > <cagazoc4tjgdbcydwrth+8cdeonl_5p9o72b4td54ykv88dh...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Did you try: x:=x > > > Jim Dorrance > [email protected] > [email protected] > www.4d.dorrance.eu > > PS: If you know of anyone that needs an experienced 4D programmer to add > energy and experience to their team, please let me know. I have > experience in many areas. Reasonable rates. Remote or Paris only. > > > ------------------------------ > > Message: 7 > Date: Wed, 15 Mar 2017 20:19:40 +0000 > From: Keisuke Miyako <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Re: tab seperated text - what to use for Cr > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > not sure if Excel supports it, (FileMaker does) > but the formal way to include multiple lines in a TSV field is to use the > vertical tab character Char(11). > > (side-note: Char(11) shows up as \v in the debugger, although you can't it in > literal text) > > if you are interested I can share a set of methods to import and export CSV > for Excel, > escaping and unescaping ", \r etc inside cells. > > > > > ------------------------------ > > Message: 8 > Date: Wed, 15 Mar 2017 20:21:19 +0000 > From: Keisuke Miyako <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Re: Weird variable (non-)refresh issue > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > to refresh variables on display, one must > > CALL PROCESS(-1) > > http://doc.4d.com/4Dv15/4D/15/CALL-PROCESS.301-2006854.en.html > >> 2017/03/16 4:56、bob.miller--- via 4D_Tech <[email protected]> のメール： >> >> I've tried throwing in a REDRAW(variablename) and even a DELAY >> PROCESS(Current process;60) - but neither has any effect. > > > > > > ------------------------------ > > Message: 9 > Date: Wed, 15 Mar 2017 21:44:24 +0100 > From: Bruno LEGAY <[email protected]> > To: [email protected] > Subject: Re: Unique Files Verification Software > Message-ID: <[email protected]> > Content-Type: text/plain; charset=windows-1252 > > Hi, > >> I’m not looking to identify all duplicates. I want to know what unique data >> might be on a disk labeled “backup"…. To determine this the software >> (rsync?) must query an index of ALL specified drives where the original >> pathname may be very different for each an every file. Can rsync perform the >> equivalent of a Finder query for each and every file on the source drive >> (the drive labeled “Backup”)? The goal is to not recycle a disk unless it >> is confirmed that all files are represented elsewhere. Does that clear >> things up? I’m not aware of any utility that offers this feature. > > rsync is very efficient at replicating a directory to another one (in an > optimal differential way). > rsync is great. There are tons of options, it can run as a > deamon/service/server. > > It has been created by the guy who wrote samba (basically reversed engineered > the Microsoft SMB protocol). > > It works from : > - local dir to local dir > - rsync server to local dir > - local dir to rsync server > > rsync will not check for duplicates within a directory. > > You can contact me privately if you need help on rsync. I use it a lot (and I > love it). > > Thinking outside of the box ZFS is a filesystem which handles compression, > encryption and deduplication. There are some NAS that are using ZFS : freenas > for instance... > > HTH > Bruno > > ------------------------------ > > Message: 10 > Date: Wed, 15 Mar 2017 14:17:07 -0700 > From: Lee Hinde <[email protected]> > To: 4D iNug Tech <[email protected]> > Subject: Larry Sharpe > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > Larry passed away last week.. Obit here: > http://www.mtdemocrat.com/obituaries/larry-sharpe/ > <http://www.mtdemocrat.com/obituaries/larry-sharpe/> > > > > ------------------------------ > > Message: 11 > Date: Wed, 15 Mar 2017 14:50:13 -0700 > From: "Randy Engle" <[email protected]> > To: "'4D iNug Technical'" <[email protected]> > Subject: RE: Larry Sharpe > Message-ID: <[email protected]> > Content-Type: text/plain; charset="UTF-8" > > Lee, > > Thanks for passing this along. > > He will be missed. > > I'm very glad that I got the opportunity to work with him on some projects > and get to know him. > > Randy Engle > XC2 Software LLC > > -----Original Message----- > From: 4D_Tech [mailto:[email protected]] On Behalf Of Lee Hinde > via 4D_Tech > Sent: Wednesday, March 15, 2017 2:17 PM > To: 4D iNug Tech <[email protected]> > Cc: Lee Hinde <[email protected]> > Subject: Larry Sharpe > > Larry passed away last week.. Obit here: > http://www.mtdemocrat.com/obituaries/larry-sharpe/ > <http://www.mtdemocrat.com/obituaries/larry-sharpe/> > > ********************************************************************** > 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] > ********************************************************************** > > > > ------------------------------ > > Message: 12 > Date: Wed, 15 Mar 2017 16:07:19 -0600 > From: "Tom Dillon" <[email protected]> > To: "4D iNug Technical" <[email protected]> > Subject: Re: Larry Sharpe > Message-ID: <[email protected]> > Content-Type: text/plain; charset=US-ASCII > > Goodnight Larry. Sweet dreams. > > -- > ------------------------------------------------------------------ > Tom Dillon 825 N. 500 W. > DataCraft Moab, UT 84532 > [email protected] 720/209-6502 > ------------------------------------------------------------------ > The butterfly will only land on you after you stop > grabbing for it. --- Sunastar > ------------------------------------------------------------------ > > > > > ------------------------------ > > Message: 13 > Date: Wed, 15 Mar 2017 15:11:20 -0700 > From: Douglas von Roeder <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Re: Larry Sharpe > Message-ID: > <CAPR+Oi_G=ufvtbterrs+gwsrek2z-gmncb38uxvi+rjeum_...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Lee: > > Sorry to hear about this. > > RIP, Larry. > > -- > Douglas von Roeder > 949-336-2902 > > On Wed, Mar 15, 2017 at 3:07 PM, Tom Dillon via 4D_Tech < > [email protected]> wrote: > >> Goodnight Larry. Sweet dreams. >> >> -- >> ------------------------------------------------------------------ >> Tom Dillon 825 N. 500 W. >> DataCraft Moab, UT 84532 >> [email protected] 720/209-6502 >> ------------------------------------------------------------------ >> The butterfly will only land on you after you stop >> grabbing for it. --- Sunastar >> ------------------------------------------------------------------ >> >> >> ********************************************************************** >> 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] >> ********************************************************************** >> > > > ------------------------------ > > Subject: Digest Footer > > ********************************************************************** > 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] > ********************************************************************** > > ------------------------------ > > End of 4D_Tech Digest, Vol 118, Issue 30 > **************************************** thanks, Aaron -- Aaron Blazer North American Marketing Solutions, Inc. | 3245 N 126th St | Brookfield, WI 53005-3187 Phone: (262)289-9200 x119 | Fax: (262)289-9208 North American Marketing Solutions, Inc. - http://www.nams-inc.com/ <http://www.nams-inc.com/> Home of 360 Direct - http://www.360direct.com/ <http://www.360direct.com/> CONFIDENTIALITY NOTE: This email and any attachments are confidential and may be protected by legal privilege. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of this email or any attachments is prohibited under applicable law. If you have received this email in error, please notify us immediately by returning it to the sender and delete this message in its entirety from your computer. ********************************************************************** 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] **********************************************************************
