Select to view content in your preferred language

How do I convert a field value to NULL?

31189
18
Jump to solution
02-12-2018 12:28 PM
StewartGalloway
Occasional Contributor

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
Frequent Contributor

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

View solution in original post

18 Replies
AbdullahAnter
Honored Contributor

Do you check if the field is nullable or not?

JamesMacKay3
Frequent 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
Honored Contributor

😮   But it is so readable and understandable unlike Python 

0 Kudos
Lake_Worth_BeachAdmin
Frequent Contributor

Python is very user friendly

0 Kudos
TedKowal
Honored Contributor

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