What version of RBASE? Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Wednesday, December 26, 2012 1:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway Excel import with carriage returns
I have the opportunity for a large task from an existing RBase client, involving replacing a rather free-form Excel spreadsheet way of tracking things into a relational database. I have the table structure mapped out, but it won't work unless I can take this 5000 row spreadsheet and get the data loaded into those tables so we have a basis to start with. The problem is that 6 of these spreadsheet columns are multi-line rows. Each of these lines represents a row I need to load into a multi-row table. If I save a sample of this data as a CSV file, and bring that CSV file up in RBedit or any text editor, I can clearly see that there are embedded carriage returns at the end of each of those lines. However, no matter whether I import it as a CSV or as an Excel spreadsheet (into an RBase Note column) it seems to strip these out and it is one run-on line. This won't help me figure out where to split the line. Has anyone done this? I have a small 2-row 4-column example that someone can play with if they think they can do it. Or if there is a way in the Excel spreadsheet to replace all carriage returns with something like a "@@" that would work too, I just don't know how. Thanks in advance! Karen
