I've got a table with a field named Maintenance Tasks. I would like to parse the values in this field into separate fields (Task1, Task2 etc.):
I can use:
None if !MaintenanceTasks! == None else !MaintenanceTasks!.split(',')
and this will parse the first item correctly into Task1, it also accounts for any null values in MaintenanceTasks.
The problem I'm running into is, for example, OID 23 above, when there's just a single item in the MaintenanceTasks field (ReplaceHead).
Any help would be greatly appreciated. FWIW I'll be scripting in Python.