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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
The character moves and there can be multiple characters. I think it may be
an enter key, but I am unsure.
 
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.
 
Back
Top