Field Contents

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

Guest

I just imported 8,000 rows of data from an Oracle database. One the the
fields (Prod) contains blanks. When I filter for Nulls, I get no results.
When I filter for empty string "" I get no results. When I filter for a
space " ", I get no results. When I go into the field and hit the delete key
a couple times and THEN filter for Nulls, I get that record.

What could possible be stored in this field? I've got to convert whatever
it is into Nulls or empty strings, but I can't figure out what's in there.
 
What could possible be stored in this field? I've got to convert whatever
it is into Nulls or empty strings, but I can't figure out what's in there.
Click to expand...

hrm. Could be a nonprinting character of some sort! Try creating a
query with a calculated field

ShowVal: Asc([fieldname])

This will return the ASCII code of the first character of the field.

If you just want to blast it out, without seeing what it is, you can
just run an Update query with no crieteria, updating the field to
Null.



John W. Vinson[MVP]
 
Hello Kirk.

Kirk P. said:
I just imported 8,000 rows of data from an Oracle database. One the
the fields (Prod) contains blanks. When I filter for Nulls, I get no
results. When I filter for empty string "" I get no results. When I filter
for a space " ", I get no results. When I go into the field and hit the
delete key a couple times and THEN filter for Nulls, I get that record.

What could possible be stored in this field? I've got to convert
whatever it is into Nulls or empty strings, but I can't figure out
what's in there.
Click to expand...

Probably, there are multiple spaces in that field.
Try to filter out all records Where Trim([Prod])=""
 
You're right, the ASC function found non-printing characters. This was an
import from an Excel file, however when I created the file as a csv, I found
the column now appropriately contains the expected Null value.

Our process will be to just create the file as csv - problem solved. Thanks
for the help!

John Vinson said:
What could possible be stored in this field? I've got to convert whatever
it is into Nulls or empty strings, but I can't figure out what's in there.
Click to expand...

hrm. Could be a nonprinting character of some sort! Try creating a
query with a calculated field

ShowVal: Asc([fieldname])

This will return the ASCII code of the first character of the field.

If you just want to blast it out, without seeing what it is, you can
just run an Update query with no crieteria, updating the field to
Null.



John W. Vinson[MVP]
Click to expand...
 
Back
Top