AnsweredAssumed Answered

ArcGIS PRO 2.2: How to change spaces to Nulls?

Question asked by buckyswider on Nov 2, 2018
Latest reply on Nov 20, 2018 by ldmitruk@edmonton.ab.ca

Like • Show 0 Likes0
Comment • 5

ArcGIS PRO 2.2: How to change spaces to Nulls?

Hi all, running a canned project "Fire ServiceMaps" in which a task wants me to append my Street Centerlines file into the LocalGovernment model. The target field is defined as a long integer that accepts null values. However, it looks like my input file has some spaces in it so the append fails with ERROR 001156.

I searched around trying to find a way to convert the spaces in my source to NULL values, but nothing I could get to work. What is the best/easiest ways to search a column for blanks and replace with NULL in Pro 2.2?

Thanks.

No one else has this question

Outcomes

5 Replies

bixb0012 Nov 2, 2018 7:19 AM
Mark Correct
Correct Answer
Since you are talking about replacing blanks with NULL, I am assuming you are looking for columns with empty strings. Do you just want to replace empty strings, "", or are you interested in replacing strings that only contain white space, e.g., " "?

If this is just a once and done, and you don't care to script it, you can use Select By Attribute to select the rows, and then use the Field Calculator and set the Expression type to Python and value to None. The Python None singleton gets converted to NULL when updating data in a table.
3 people found this helpful
Like • Show 2 Likes2
Actions
- buckyswider @ bixb0012 on Nov 2, 2018 7:53 AM
  Mark Correct
  Correct Answer
  I believe I just want to change whitespace " " to nulls. Will Select By Attribute allow me to select by column instead of rows? There are other columns that have legitimate space characters.
  
  As Michael knows from my "main" thread for my task, I'm an ArcGIS newbie with some limited python knowledge, so I'm slowly feeling my way through to get run books created for my fire company.
  
  Also as Michael points out, I may have a data type mismatch- not sure which situation is occurring. I guess I should try one "fix" at a time so I can figure out what exactly the culprit is, as this will be an annual/biennial process....
  Like • Show 0 Likes0
  Actions
mvolz47 Nov 2, 2018 7:40 AM
Mark Correct
Correct Answer
You say the target of the LGIM feature class is integer, but what is the field type of your input Street Centerline feature class? What is the name of the target field? This might not be the only field that you are going to have this issue with as the error MIGHT occur on the first instance it hits and then it exits the geoprocessing task without moving on to additional fields.

Did you get this data from the county that you are also trying to get address points from? If so, then is does not look like they are using the LGIM for street centerlines, so they probably don't have address points in the LGIM either.
1 person found this helpful
Like • Show 1 Like1
Actions
- buckyswider @ mvolz47 on Nov 2, 2018 7:47 AM
  Mark Correct
  Correct Answer
  Hmmm, good point- the source table lists as TEXT. So I wonder if the failure is on a Space character (as the 001156 text says " ") or on the datatype. Or maybe both. So maybe I have to somehow convert the entire column to long integer and any spaces will take care of themselves during that operation???
  Like • Show 0 Likes0
  Actions
  - ldmitruk@edmonton.ab.ca @ buckyswider on Nov 20, 2018 2:03 PM
    Mark Correct
    Correct Answer
    Try adding a new field as a long integer type and then calculate the value by using the int() function in the calculate field tool.
    
    For example: int(!OldField!)
    
    I would then select the rows with spaces in old column and calculate them to None just to be sure.
    
    Cheers
    Like • Show 0 Likes0
    Actions

GeoNet

The Esri Community

ArcGIS PRO 2.2: How to change spaces to Nulls?

Outcomes

Related Content

Recommended Content