On Mon, Jul 13, 2015 at 10:46 AM, Tracy Pearson <[email protected]> wrote: > Ted Roche wrote on 2015-07-13: >> >> _VFP.DataToClip(SELECT(), RECCOUNT(), 3) >> >> to paste a tab-delimited columnar block into the Windows clipboard. >> > > Ted, > > I was thinking you could... > You might be able to use the Reduce() function in the FoxTools.FLL. It will > reduce double space to a single space. > You would manipulate the _ClipText variable
Genius! I didn't think of messing with the clipboard data once it was posted there. > After dumping _ClipText to a file with StrToFile() it looks like the output > created by DataToClip() is Space Delimited No, the ,3 parameter on DataToClip makes it tab-delimited, and pasting into LibreOffice Calc pops up a dialog that let's you specify column separators and text delimiters and "special number" detection. Pretty cool stuff. If I MODI FILE the resulting StrToFile(_ClipText)) and set Preferences, WordWrap off, I can see the columnar text, and moving the cursor through it, the jump when it hits the invisible tab characters, if I: teststring=_ClipText DO WHILE OCCURS(chr(32)+chr(9),teststring)>0 STRTRAN(CHR(32)+CHR(9),teststring,CHR(9)) ENDDO _cliptext = teststring I get truncated strings and it imports into the spreadsheet all trimmed up. Thanks for the clue! -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4tfz4myheypjdep6v6+vzn+u2tuh14dr0xjqfzb0tp...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
