How do I remove a character after an import from .csv

[Guest]

I have a character that looks like an open box that is being imported with my
data. How do I prevent it from being imported, or how do I clean it up after
the fact?

I ma not sure what the character represents.

Dave

 

[Guest]

It's probably a non-printable ASCII character. They can be a PITA. Is the
character always in the same position such as the first or last character? If
so, it could be an easy fix.

 

[Guest]

The character moves and there can be multiple characters. I think it may be
an enter key, but I am unsure.

 

[Pete D.]

It is an enter key usually brought in from an excel cell with a forced
return in it. Sometimes you can see it and sometimes you can't and it
disappears sometimes when you put the cursor in the field making it hard to
manually remove. If you know the ASCII for it you can strip it out with an
update query. Pete D.

 

[Guest]

Is there a way to figure out the ascii value?

Dave

 

[Pete D.]

See http://support.microsoft.com/kb/210372 for the corrective action. Pete
D.

 

[Guest]

Thanks

See http://support.microsoft.com/kb/210372 for the corrective action. Pete
D.