Bad character in a database field - finding and eliminating

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

Guest

Hi,

I have a table with a character showing up occasionally in one of the
fields. It shows in the table view as a little square (tab maybe?). I'd
like to be able to find it and delete from each record in my table.

By the way, the field is an Address field. For example:

7083 Hollywood Boulevard
Sixth Floor

((interesting that after copying it it pasted the field just like above - a
carriage return character of some sort?))

If I have to do it manually I'll do it. I tried to do a copy and paste this
into a Find window to no avail. I can't paste it.

The result of this strange character is that when I export the table to a
CSV file, the records that have it are getting a 2nd line (right after the
character the remaining data of the records are knocked down to a new line).

Can anybody help with this?

Thanks,

Patrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Special characters 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Find records containing special characters in a field 4
Strange Asian looking characters in output 3
Foreign Characters (Japanese) appear in Database Table 1
Count field length in delimeted file and compare with predefined listof field length 8
Find and wipeout 3
require # characters in field 3

Back
Top