change a value to NULL?

[Bell, Kevin]

I'm pulling a list of numbers from MS Excel, but occasionally if there
is no data from excel, the value is an asterisk, but I need to make it
null.

What is the best way to do that? Thus far, I'm using:


for value in myRange:
try:
intV = int(value)
print intV
except:
print "its an asterisk"


but I need to get at my list and substitute the *'s with nulls to load
into a database.

Thanks.

Kevin Bell

[Brett Hoerner]

Re: change a value to NULL?

I'm not sure what you mean, really, do you need an official Python
"Null" value? Try None?

In [6]: myCells = ['Mary', 'Bob', None, 'Joe']

In [7]: for cell in myCells:
...: if cell:
...: print cell
...: else:
...: print "NULL VALUE"
...:
Mary
Bob
NULL VALUE
Joe

--

As far as having a Null value to put into the DB, most (SQL) DB's I've
used have a specific SQL command like "INSERT INTO ROW VALUE NULL()",
kind of like the SQL DATE(), etc. I'm really rusty on my syntax etc
right now btw so don't copy and paste that. :P

[Steve Holden]

Re: change a value to NULL?

Brett Hoerner wrote:[color=blue]
> I'm not sure what you mean, really, do you need an official Python
> "Null" value? Try None?
>
> In [6]: myCells = ['Mary', 'Bob', None, 'Joe']
>
> In [7]: for cell in myCells:
> ...: if cell:
> ...: print cell
> ...: else:
> ...: print "NULL VALUE"
> ...:
> Mary
> Bob
> NULL VALUE
> Joe
>
> --
>
> As far as having a Null value to put into the DB, most (SQL) DB's I've
> used have a specific SQL command like "INSERT INTO ROW VALUE NULL()",
> kind of like the SQL DATE(), etc. I'm really rusty on my syntax etc
> right now btw so don't copy and paste that. :P
>[/color]
And besides that, Excel is a spreadsheet not a database :-)

regards
Steve
--
Steve Holden +44 150 684 7255 +1 800 494 3119
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/