IF- ELSE script in the field calculator (number classification)

[RTMRTM]

I have a field where they stored phone numbers, called "Sent Phone"

in my country the phone numbers have 8 characters

I made a field called "Length" ,to find out how many characters the field has "Sent Phone"

then I made a field called "New Phone"  to classify only numbers that have 8 characters

I need to make a script that pastes the numbers that have 8 catechists in "New Phone" and if it doesn't have 8, put 0

ID	Sent Phone	Length	New Phone
1	3	1	0
2	22	2	0
3	213	3	0
4	1	1	0
5	33445678	8	33445678
6	11	2	0
7	2	1	0
8	12569826	8	12569826
9	12560912	8	12560912
10	34235677	8	34235677

sorry for my bad English

[JoeBorgione]

In your illustration, have you updated the Length field already, or is that to be part of the script?

My first thought is to use an update cursor with arcpy or do you want to keep this at the field calculator level?

[RTMRTM]

In your illustration, have you updated the Length field already, or is that to be part of the script?

R//I currently have the length field updated

My first thought is to use an update cursor with arcpy or do you want to keep this at the field calculator level?

R// I would like to keep it from the field calculator

[DavidPike · Accepted solution]

code:

func(!Sent Phone!)

pre-logic script:

# only works for a string, add some
#logic to test for str, int float etc
#then if/else it in a similar block
def func(input):
    if len(input) == 8:
        result = input
    else:
        result = '0'
    return result‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[JoshuaBixby]

In addition to David's answer, this can be accomplished with a one-liner in the expression block that doesn't require a pre-calculated length field:

!Sent Phone! if len(!Sent Phone!) == 8 else '0'‍

[DavidPike]

on looking back at my answer I'm also missing quotes to make 0 a string. Have edited or will try if able. Loving the one liner Joshua!

[RTMRTM]

I have a problem:

the script works perfectly, add it as precess in modelbuilder

it works for me when I have modelbuilder open,

but when I run it from the sale of parameters it doesn't work

returns this error

[DavidPike]

Sharing the full error message would be helpful

[RTMRTM]

Executing (Calculate Field): CalculateField "C:\Users\Shp_salida\001.shp"
 Phone func( !Telefono_C! ) PYTHON_9.3 "def func(input):\n    if len(input) == 8:\n        result = input\n    else:\n        result = 0\n    return result\n"
Start Time: Thu May 21 15:59:34 2020
ERROR 000539: Error running expression: func( 5 )
Traceback (most recent call last):
  File "<expression>", line 1, in <module>
  File "<string>", line 2, in func
TypeError: object of type 'int' has no len()

Failed to execute (Calculate Field).
Failed at Thu May 21 15:59:34 2020 (Elapsed Time: 0.01 seconds)
Failed to execute (Model72).
Failed at Thu May 21 15:59:34 2020 (Elapsed Time: 1.34 seconds)

[DavidPike]

Ok so an integer is being passed into the function. Replace if len(input) with if len(str(input))