How do I convert a field value to NULL?

22535
18
Jump to solution
02-12-2018 12:28 PM
StewartGalloway
New Contributor III

How do I convert a field value to NULL?  I tried Calculate. Not sure how to use Python = "none" but I could not get it to work.

Thanks.

Stew

1 Solution

Accepted Solutions
JamesMacKay3
Occasional Contributor

Try "None" without surrounding quotes (it's also case-sensitive).

View solution in original post

18 Replies
AbdullahAnter
Regular Contributor II

Do you check if the field is nullable or not?

JamesMacKay3
Occasional Contributor

Try "None" without surrounding quotes (it's also case-sensitive).

DanPatterson_Retired
MVP Esteemed Contributor

In summary, make sure the field is nullable and you use the python parser when typing ... None ....

since None is a python object for sure... not sure about other parsers.

JoeBorgione
MVP Esteemed Contributor

Null in VB.

That should just about do it....
DanPatterson_Retired
MVP Esteemed Contributor

don't encourage vb Joe

TedKowal
Regular Contributor II

😮   But it is so readable and understandable unlike Python 

0 Kudos
Lake_Worth_BeachAdmin
Regular Contributor

Python is very user friendly

0 Kudos
TedKowal
Regular Contributor II

Just like Perl!  Even though I respectfully disagree!  I find it to be an awful language...but who am I to say... the masses embraced it so in order to progress I have to deal with it!

0 Kudos
DanPatterson_Retired
MVP Esteemed Contributor

Come on Ted... you are getting behind... more on the horizon   for instance...  https://julialang.org/

0 Kudos