nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Operativo_GISRTM_GIS

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

Encuentra más publicaciones etiquetadas con

Accepted answers

DavidPike

code:

func(!Sent Phone!)

pre-logic script:

<SPAN class="comment token"># only works for a string, add some</SPAN>
<SPAN class="comment token">#logic to test for str, int float etc</SPAN>
<SPAN class="comment token">#then if/else it in a similar block</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">func</SPAN><SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN>
        result <SPAN class="operator token">=</SPAN> input
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        result <SPAN class="operator token">=</SPAN> <SPAN class="string token">'0'</SPAN>
    <SPAN class="keyword token">return</SPAN> result‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

DavidPike

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

Operativo_GISRTM_GIS

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

Sharing the full error message would be helpful

Operativo_GISRTM_GIS

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

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!

bixb0012

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! <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>!Sent Phone!<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">8</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="string token">'0'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

DavidPike

code:

func(!Sent Phone!)

pre-logic script:

<SPAN class="comment token"># only works for a string, add some</SPAN>
<SPAN class="comment token">#logic to test for str, int float etc</SPAN>
<SPAN class="comment token">#then if/else it in a similar block</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">func</SPAN><SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>input<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">8</SPAN><SPAN class="punctuation token">:</SPAN>
        result <SPAN class="operator token">=</SPAN> input
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        result <SPAN class="operator token">=</SPAN> <SPAN class="string token">'0'</SPAN>
    <SPAN class="keyword token">return</SPAN> result‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Operativo_GISRTM_GIS

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

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?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.