How to turn a string field with 2 numbers in two numerical fields in the atribute table?

Question

I have a feature class with a big number of features.

In the attribute table I have a string field made from two numbers separated by an underline (e.g.: 0_1, 98_237, 31_31...). I want to create two new numerical (long integer) fields with the numbers before and after the underline (e.g.: 0_1 0 1, 98_237 98 237, 31_31 31 31...)

How can I do this using field calculator?

Answer 1

within the filed calculator, you can use python statement with the split() function

with the first number, it will be

int(!field!.split("_")[0]) #creates a list of items separated by the _, and take the first item

and for the second number

int(!field!.split("_")[-1]) #creates a list of items separated by the _, and take the last item (if you have only 2 items, you could also use 1(= the second item in Python index)

int() is not necessary if you have an integer field as output, but I prefer to use it so that the conversion is obvious. If your number are floating points, use "float()" instead of "int()"