Aha! Now why didn't I think of that! Yes, using a VarChar field preserves the carriage returns! So now the BLOB editor clearly shows multiple lines of data within that column.
>From there I wrote a cursor to step through the value character by character >and test for the CR/LF. Several combinations had to be tested until I found >that a simple CHAR(010) by itself was recognized. So that will enable me to >parse the string! So far so good, potential project moving forward! Thanks Albert, and Merry Christmas! Karen -----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Dec 26, 2012 2:02 pm Subject: [RBASE-L] - Re: Gateway Excel import with carriage returns 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 >
