Importing data into RevDB
davidocoker at gmail.com
Fri Dec 4 18:59:38 EST 2009
>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..
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
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. :-)
More information about the Use-livecode