topic Re: ModelBuilder VB to Python Conversion in Python Questions

ModelBuilder VB to Python Conversion

CTalbot — Fri, 28 Oct 2022 20:38:42 GMT

Hello,

I'm writing for some assistance in troubleshooting converting an old Model from VB script to Python.

The specific area giving me trouble is a Calculate Field Expression

here's what I started with:

=[AREA_CODE] & Replace ([BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER], " ", "")

this gave error00539 'Replace' is not defined

Here's a couple things I attempted:

!AREA_CODE! & Replace (!BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER!, " ", "")

^same error code

!AREA_CODE! + replace (!BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER!, " ", "")

^same error code

!AREA_CODE! + (!BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER!, " ", "")

^error 00539-TypeError: can only concatenate str (not "tuple") to str

!AREA_CODE! + tuple(!BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER!, " ", "")

^error 00539-TypeError: tuple expected at most 1 arguments, got 3

!AREA_CODE! + [tuple(!BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER!, " ", "")]

^error 00539-Syntax error: invalid syntax

I'm at a bit of a loss as to what to try next

please let me know what you think

Sincerely,

Christopher

@arcgis_python

Re: ModelBuilder VB to Python Conversion

Brian_Wilson — Fri, 28 Oct 2022 22:01:20 GMT

I am thinking the REPLACE part is doing nothing but maybe convert a numeric field to a string The str() will pretty much turn anything into a string, so this seems like it would be safe.

str(!AREA_CODE!) + str(!BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER!)

Re: ModelBuilder VB to Python Conversion

DanPatterson — Fri, 28 Oct 2022 23:01:47 GMT

Assuming that you want to concatenate the two fields and remove spaces in the longer field name. "str"ing both fields in case a number to text conversion is necessary.

str(!AREA_CODE!) + str(!BIDDER_PERCENTAGES_TABLE_SELECT_BLOCK_NUMBER!).replace(" ", "")

Re: ModelBuilder VB to Python Conversion

CTalbot — Mon, 31 Oct 2022 12:41:45 GMT

Hello, thank you much!

Re: ModelBuilder VB to Python Conversion

CTalbot — Mon, 31 Oct 2022 12:42:53 GMT

Hello, Thank You much!