How do I convert a field value to NULL?

13373
18
Jump to solution
02-12-2018 12:28 PM
Highlighted
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
Highlighted
Occasional Contributor

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

View solution in original post

18 Replies
Highlighted
Regular Contributor II

Do you check if the field is nullable or not?

Highlighted
Occasional Contributor

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

View solution in original post

Highlighted
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.

Highlighted
MVP Esteemed Contributor

Null in VB.

Highlighted
MVP Esteemed Contributor

don't encourage vb Joe

Highlighted
Regular Contributor II

😮   But it is so readable and understandable unlike Python 

Reply
0 Kudos
Highlighted
Regular Contributor

Python is very user friendly

Reply
0 Kudos
Highlighted
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!

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

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

Reply
0 Kudos