topic Re: Python: If Then with Left Equivalent in Python Questions

Python: If Then with Left Equivalent

MichaelWalden — Tue, 24 Oct 2017 14:35:14 GMT

Trying to calculate using Python in 10.3 the "Region" field with text based on the first two characters in a string field called "API_10". Basically, if the left two characters in "API_10" equal "33", then populate "Region" with "North".

Re: Python: If Then with Left Equivalent

JoshuaBixby — Tue, 24 Oct 2017 15:06:36 GMT

API_10[0:2] or API_10[:2]

Re: Python: If Then with Left Equivalent

DanPatterson_Retired — Sun, 12 Dec 2021 02:29:00 GMT

Joshua is correct... python slicing is 0 based and exclusive of the slice number, hence

whatever[:2] or whatever[0:2] will return 0 and 1. The slice is [start:stop:step]

whatever = 'abcdefg'

whatever[0:6:2]
'ace'

whatever[:6:2]
'ace'‍‍‍‍‍‍‍

or skipping the start and stop

whatever[:6]
'abcdef'‍‍

Re: Python: If Then with Left Equivalent

JoshuaBixby — Tue, 24 Oct 2017 15:19:28 GMT

Also, just pass the whole column to your function since the function does slicing and checking: Region = TextValue(!API_10!)

Re: Python: If Then with Left Equivalent

TedKowal — Tue, 24 Oct 2017 15:24:30 GMT

When you do a slice or substring in Python and it starts with "0" then the second number is always the length. This confused me for a while ..... https://www.dotnetperls.com/substring-python

Re: Python: If Then with Left Equivalent

DanPatterson_Retired — Tue, 24 Oct 2017 15:30:33 GMT

Or the most succinct descriptor... the python docs

Re: Python: If Then with Left Equivalent

MichaelWalden — Tue, 24 Oct 2017 16:15:24 GMT

Thanks Joshua!