David, 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. HTH On Fri, Dec 4, 2009 at 12:46 PM, David Coker <[email protected]> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
