Importing data into RevDB
Kay C Lan
lan.kc.macmail at gmail.com
Sat Dec 5 15:08:24 EST 2009
Prior to exporting from Excel, do a Repace All 'tabs' with "tttt" and
replace all line breaks with "lblblblb" (obviously you can use any number of
and combination of characters that you are confident will never appear in
the data). Then export it as tab delimited.
Every line of the resulting file will represent a row of data
Everything between tabs will be a column
Extremely easy to parse then with Rev, and just prior to sending the data to
it's final destination you reinsert the tabs and linefeeds.
On Fri, Dec 4, 2009 at 12:46 PM, David Coker <davidocoker at gmail.com> wrote:
> Hello folks,
> I'm in the planning stages of a possible new app which will include
> populating a Rev Database (SQLite) primarily from a standard Excel based CSV
> file. What I've run into while doing some research is that that format seems
> leaves a lot to be desired. It seems that the CSV data that I'll be working
> with has all kinds of spurious line breaks and such embedded, so converting
> to a tab delimited format doesn't work well.
> Does anyone have any suggestions as to how to make something like this
> reliable as far as maintaining record integrity during import?
> Best regards,
> David C.
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode