Re: Getting data out of Excel

2013-07-25 Thread Dr. Hawkins
On Wed, Jul 24, 2013 at 5:37 AM, Richard Gaskin ambassa...@fourthworld.com wrote: https://www.libreoffice.org/ Which is my solution. Copy from libreoffice, paste into a table, and I'm done. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___

Re: Getting data out of Excel

2013-07-24 Thread Kay C Lan
If you are absolutely sure that the clipboardData[text] has return represented by six spaces, and tabs by 3 spaces, then: put clipboardData[text] into tData replacewith return in tData repace with tab in tData Will only take milliseconds to do what you need! How much quicker do you

Re: Getting data out of Excel

2013-07-24 Thread dunbarx
-Original Message- From: Kay C Lan lan.kc.macm...@gmail.com To: How to use LiveCode use-livecode@lists.runrev.com Sent: Wed, Jul 24, 2013 2:42 am Subject: Re: Getting data out of Excel If you are absolutely sure that the clipboardData[text] has return represented by six spaces, and tabs by 3 spaces

Re: Getting data out of Excel

2013-07-24 Thread Richard Gaskin
Michael Julian wrote: I used to be able to just paste, but nowadays (Excel 2011 Mac OSX 10.7.4) the data come in as a long string, with six spaces where a return should be and three where a tab should be. That seems a silly format, even by Microsoft standards (ever looked at the bizarre

Getting data out of Excel

2013-07-23 Thread Michael Julian Lew
I'm trying to paste data from MS Excel into a table in my Livecode stack without success. I suspect that either OSX or Excel have added unwelcome complications. I used to be able to just paste, but nowadays (Excel 2011 Mac OSX 10.7.4) the data come in as a long string, with six spaces where a