[ic] Removing carriage returns from description
DB at m-and-d.com
Sat Dec 6 17:14:33 EST 2003
I'm sure this has come up before.. I think I even figured it out once.
A supplier provided me with a product database in csv format. I can
import it into Excel or Access and it is formatted ok. But the
description fields contain carriage returns (I think that's what they
are) which show up as squares. These are causing problems when I try to
export to a text file. How can I remove these pesky critters? I've tried
many things such as fromdos in linux but can't quite get what I want.
Any hints? magic perl snippets?
More information about the interchange-users