Using Field Calculator for turning a string into an integer while removing text...

AdrianWelsh

I feel kind of dumb but I cannot figure out how to make this work.

This should be easy, I think, but field calculator is making it difficult for me. I have one field that has text and numbers. I want to use Field Calculator with Python to just grab those numbers and put them into my Long Integer field.

I tried using the example from Stack Exchange but maybe I am doing it wrong because this example is making it a string?

(this returns nothing in my records)

What am I doing wrong?

JamesCrandall

You need to check if the list you are building contains any digits because if you return anything with only text it will bomb since the field you are calculating is type Integer.

def makestr(test):
     numlist = [] 
     for s in test:
         if s.isdigit():
             numlist.append(s)
     retlist = ''.join(numlist) 
     if any(char.isdigit() for char in retlist):
         return retlist