topic Re: using (if namefield LIKE '% value%') in Python Questions

using (if namefield LIKE '% value%')

CarlosBustamante — Sun, 12 Dec 2021 00:18:53 GMT

I am calculating a field with arcpy, but I have not been able to obtain the expected results.

expression2="getClass(!DESCRIPCION!)"

codeblock2="""def getClass(DESCRIPCION):

    if '"DESCRIPCION" LIKE ' + "'%CODE%":
        return 1 """

arcpy.CalculateField_management(in_table=out_gdb +   "\Compilado\AccesoriosLineasMecanicas",
                                field="TIPO_EMPALME",
                                expression=expression2,
                                expression_type="PYTHON_9.3",
                                code_block=codeblock2)

for all records in the TIPO_EMPALME field the result is 1, I should do a filter for %CODE%

Re: using (if namefield LIKE '% value%')

JoshuaBixby — Sun, 12 Dec 2021 00:18:55 GMT

You are setting the code block to Python but using SQL syntax, so it isn't a surprise the code isn't working. Try using Python syntax, something along the lines of:

if 'CODE' in DESCRIPCION:
    return 1‍‍

Re: using (if namefield LIKE '% value%')

JoshuaBixby — Fri, 13 Dec 2019 23:53:58 GMT

Carlos Bustamante‌, still having issues?