Re: Getting data out of Excel

On Wed, Jul 24, 2013 at 5:37 AM, Richard Gaskin wrote: > Which is my solution. Copy from libreoffice, paste into a table, and I'm done. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ use-livecode mailing list u

Re: Getting data out of Excel

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 r

Re: Getting data out of Excel

-Original Message- From: Kay C Lan To: How to use LiveCode 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, then: put clipboardData["text"

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, then: put clipboardData["text"] into tData replace " " with return in tData repace " " with tab in tData Will only take milliseconds to do what you need! How much quicker do

Getting data out of Excel

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 r