problem importing tab delimited text files
davidocoker at gmail.com
Sat Jan 15 17:53:10 EST 2011
On Sat, Jan 15, 2011 at 4:21 PM, Ian McKnight <iangmcknight at gmail.com> wrote:
> Hi all
> I have a table of data in an excel spreadsheet.40 rows x 30 columns approx.
> I save the file as a tab delimited text file for import into LC.
> I import the file and its empty - nothing there in LC.
> I open the text file in Notepad and save it again, making no changes.
> I import the same file into LC again and all the data is where it should be.
> My question is what could be preventing LC from importing an 'Excel' text
> file (or perhaps failing to detect the information it contains) since there
> are no errors generated.
> I thought that this problem was an aberration on my part but no it has
> reappeared this evening.
> Any pointers would be greatly appreciated.
> Using LC 4.5.1 on Win 7
> Ian McKnight
> iangmcknight at gmail.com
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
I use tab delimited files from excel all the time without any
difficulties... same exact platform and LC version.
Based on your description, I'd try to open just a simple text file
without tabs, just to verify that the intended file is being opened
successfully. (Been there, done that, more than once)
Also, make sure to set the itemdelimiter to tab. (Been there, done that also)
It has always been solid as a rock for me on this end and I cannot
imagine any other scenario where it would fail.
More information about the Use-livecode