Getting Rid of Funny Characters

  • Thread starter Thread starter Powderfinger
  • Start date Start date
P

Powderfinger

I imported an excel spreadsheet and everything went well except some of the
address fields have invalid characters in them, usually at the beginning of
the field (a little square appears in the field). I open the table and put
the cursor in the field and the whole field disappears.

Is there any way I can remove these?

Access 2003

Thanks

Jack
 
I imported an excel spreadsheet and everything went well except
some of the address fields have invalid characters in them,
usually at the beginning of the field (a little square appears in
the field). I open the table and put the cursor in the field and
the whole field disappears.

Is there any way I can remove these?

Access 2003

Thanks

Jack
Click to expand...
Usually those squares represent a formatting character, like a
linefeed, or a tab.

Build a query to see.
Open the query builder indesign view, Select your table. Double-
click on the address field to put it into the grid. type asc([ in
front of the field name, and ]) after it.
double-click on the field again to see it unchanged.

When you run the query yur first column will be a number. The
offending ones are probably < 32.

If they are, put < 32 as the criteria for that column, then change
the query to an update query.
havi it update the address field to mid([<address>],2), replace
<address> with the name in your table.
Run hte query. The boxes should be gone,

The ones in the middle of the field are a little more tricky. If
there are only a few, you can edit them by pressing the shift-F2
keypress to open up a window where you should be able to work
 
Try the Zoom mode by pressing Shift-F2 on these fields. If these are
LineFeed or CarriageReturn control characters, you should see a white line
at the top of the address.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


Bob Quintal said:
I imported an excel spreadsheet and everything went well except
some of the address fields have invalid characters in them,
usually at the beginning of the field (a little square appears in
the field). I open the table and put the cursor in the field and
the whole field disappears.

Is there any way I can remove these?

Access 2003

Thanks

Jack
Click to expand...
Usually those squares represent a formatting character, like a
linefeed, or a tab.

Build a query to see.
Open the query builder indesign view, Select your table. Double-
click on the address field to put it into the grid. type asc([ in
front of the field name, and ]) after it.
double-click on the field again to see it unchanged.

When you run the query yur first column will be a number. The
offending ones are probably < 32.

If they are, put < 32 as the criteria for that column, then change
the query to an update query.
havi it update the address field to mid([<address>],2), replace
<address> with the name in your table.
Run hte query. The boxes should be gone,

The ones in the middle of the field are a little more tricky. If
there are only a few, you can edit them by pressing the shift-F2
keypress to open up a window where you should be able to work
Click to expand...
 
Back
Top