[ic] Import / Export in Excel carriage returns

[Alex Lam <alex@integricity.com>]

Hi folks...

Have you guys encountered problems after importing / exporting data in
Excel where the end of line characters are taken into the SQL database
and muck up your values ?

For instance, I entered some products thru the web interface into
category abc and when I entered a whole bunch more in Excel, they
appeared as abc^M or abc\r

So, when the category in the left nav bar is clicked I'd get

--------------
|    abc     |
------------------------------
| products                   |
------------------------------
--------------
|    abc     |
------------------------------
| products                   |
------------------------------

It's because the search sees abc and abc\r as two diff values. I know
I can do a complex search, but that is not getting to the root of the
problem. Any gurus with advice?

Thanks.

Alex Lam



_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users