For a beginner, there are three important concepts to accomplish this:
- How to use the codeblock part of the Field Calculator to write
and call a function
- How to test for null values
- How to return the first or last four characters of a string
I will explain each of these concepts below.
Item 1: You need to check "Python" and "Show Codeblock", then write a function definition in the "Pre-Logic Script Code" box.
Here is a function definition, which should be placed in your Pre-Logic Script Code. I named this function "find":
def find(dateasbuilt, project):
if dateasbuilt is not None:
elif dateasbuilt is None:
Then you call the function in the box below, using the function name and the fields that you need it to reference.
So your calculated value should be set to
find( !DateAsBuilt!, !Project!)
Here is a screen-capture:
Item 2: Python uses "None" to represent null. Testing for null values using Python in a text field, you must test for "is None" or "is not None" ... note that a null value is never EQUAL TO Null. It either "is null" or "is not null" but cannot be evaluated using the = (equals sign).
Item 3: You can use Python slice notation to select the first or last four characters of a string. String[:4] will give the first four characters (up to, but not including the character at index 4, where strings are indexed starting at zero). String[-4:] will give the last four characters (all characters including and after the fourth-to-last character).
More on slice notation: https://stackoverflow.com/questions/509211/understanding-slice-notation