How do I get rid of Null character (Catobase)?

tdneu · 07-01-2005, 09:49 PM

I'm getting the "incorrect team abbreviations" error during Import, even though they are the same from prior years. I know a bit about Access, and have isolated the Null character in several of the tables. I've seen other users describe this as an "easy fix", but I can't figure out how to do it.

For instance, in the Teams table, at the bottom in the * row is a zero (0), which Access says is a null character. In previous seasons (that imported correctly), this character was not present in this table. How do I get rid of it though? I can't capture it, nor get rid of it with Find/Replace. What command do I use?

Any help/insight would be appreciated. I'm at year 47 in a replay, and don't want to start over.

Malleus Dei · 07-01-2005, 11:40 PM

You might download an evaluation copy of Boxer Software's Text Monkey and see if it will do the job.

SandMan · 07-02-2005, 12:11 AM

The easiest way is to open the table in MSACCESS. Create a query that gets all the records with a NULL in the manager field or nickname field. Change the query to an update query and update the fields that contain a null but should be blank to IS NOT NULL. You cannot change it to spaces, it will rewrite as a null but you can change it to the IS NOT NULL value, which will load spaces into the field.

Long_Long_Name · 07-02-2005, 07:56 AM

I can't very much help, sadly. I've had a null character once, but I had simply not input a manager name for a certain team (I added one, and it solved the issue).

07-01-2005, 09:49 PM	#1
tdneu Minors (Double A) Join Date: Jun 2004 Posts: 180	How do I get rid of Null character (Catobase)? I'm getting the "incorrect team abbreviations" error during Import, even though they are the same from prior years. I know a bit about Access, and have isolated the Null character in several of the tables. I've seen other users describe this as an "easy fix", but I can't figure out how to do it. For instance, in the Teams table, at the bottom in the * row is a zero (0), which Access says is a null character. In previous seasons (that imported correctly), this character was not present in this table. How do I get rid of it though? I can't capture it, nor get rid of it with Find/Replace. What command do I use? Any help/insight would be appreciated. I'm at year 47 in a replay, and don't want to start over.

07-02-2005, 07:56 AM	#4
Long_Long_Name Hall Of Famer Join Date: Jan 2002 Location: Montréal Posts: 7,065	I can't very much help, sadly. I've had a null character once, but I had simply not input a manager name for a certain team (I added one, and it solved the issue). __________________ Beta Baseball. Join it!

07-02-2005, 12:11 AM	#3
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	The easiest way is to open the table in MSACCESS. Create a query that gets all the records with a NULL in the manager field or nickname field. Change the query to an update query and update the fields that contain a null but should be blank to IS NOT NULL. You cannot change it to spaces, it will rewrite as a null but you can change it to the IS NOT NULL value, which will load spaces into the field.