Importing data into RevDB

David Coker davidocoker at gmail.com
Fri Dec 4 18:59:38 EST 2009


Hi Richard!
>If you have it in Excel, can you export it using tab-delimited?

Yes sir, been there and tried that several different ways. Unfortunately, that creates issues of a different sort. As a really poor example, this is one of the things I continue to run across after converting to tabbed format..

Original example:
blah blah,"doodah somestupidgarbagecharacterorlinefeed doodah doodah",12345abc

Converted to tab delimited:
blah blah(tab)"doodah somestupidgarbagecharacterorlinefeed doodah doodah"(tab)12345abc

When saved, tab delimited format all too often renders something like this:

blah blah,"doodah somestupidgarbagecharacter 
doodah 
doodah"(tab)12345abc

Gone is any hope of reusing the file data.

That was actually the whole point of my original question about importing csv into a database. At that point I could likely pull the data out field by field as required and run scanners to clean it up enough to be used in a tab delimited format. At that point, it would be easy to work with using Rev in any number of ways.

BTW, I used your Webmerge program last night for the first time in a pretty long while... As part of a test run I was doing, it created 81,000+ html pages in just over 90 minutes. :-)

Regards,
David C.



More information about the Use-livecode mailing list