How do I convert a field value to NULL?

27148
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
Occasional Contributor III

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 Emeritus

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 Emeritus

Null in VB.

That should just about do it....
DanPatterson_Retired
MVP Emeritus

don't encourage vb Joe

TedKowal
Occasional Contributor III

😮   But it is so readable and understandable unlike Python 

0 Kudos
Lake_Worth_BeachAdmin
Occasional Contributor III

Python is very user friendly

0 Kudos
TedKowal
Occasional Contributor III

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 Emeritus

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

0 Kudos