A possibility is to to bring the data into a VARCHAR column rather than
a NOTE column. VARCHAR accepts carriage returns.
Albert
On 26/12/2012 12:32 PM, Karen Tellef wrote:
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 5000row
spreadsheet and get the data loaded into those tablesso 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
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2013.0.2805 / Virus Database: 2637/5988 - Release Date: 12/26/12
