topic Re: Python get two values in a Search Cursor than go to next line in Python Questions

Python get two values in a Search Cursor than go to next line

deleted-user-MS0lE1F_0-sy — Sat, 11 Dec 2021 23:49:35 GMT

I am trying to write my getValues to a text element loop, but I want there to be two results per line before going to the new line. I am having trouble figuring it out? I think I might new a while loop perhaps instead of a for loop, and probably need to use next() somewhere? But that seems to just loop through each name and put one result instead of all four.

I don't want this: Anna I want this: Anna Ben

Ben Charlie Dora

Charlie

Dora

I don't know what to use in here to achive this.

rows = arcpy.SearchCursor(Layer)
        textValue = ""
        for row in rows:
            textValue += row.getValue(Value1) + '\r\n'
        ParcelText2.text = textValue
        del rows

Re: Python get two values in a Search Cursor than go to next line

IanMurray — Sat, 11 Dec 2021 23:49:38 GMT

should be fairly easy to use a counter or something similar to check.

rows = arcpy.SearchCursor(Layer)  
textValue = ""  
for row in rows:  
    count = 1
    if count/2.0.is_integer() == False:
         textValue += row.getValue(Value1) + ' '
         count += 1
    else: 
         textValue += row.getValue(Value1) + '\r\n' 
         count += 1        
ParcelText2.text = textValue  
del rows

Re: Python get two values in a Search Cursor than go to next line

TomSellsted — Thu, 18 Jun 2015 15:29:40 GMT

Matthew,

Some logic like Ian describes will work. You can use the modulo operator to accomplish this too.

if (count%2) == 0:

Regards,

Tom

Re: Python get two values in a Search Cursor than go to next line

IanMurray — Thu, 18 Jun 2015 15:31:43 GMT

That was probably the better one to use, my general python gets rustier and rustier I feel like since I am only use python within the arcpy module these days(and with a limited usage at that!).

Re: Python get two values in a Search Cursor than go to next line

TomSellsted — Thu, 18 Jun 2015 15:43:39 GMT

There are always lots of different ways to solve problems!

Re: Python get two values in a Search Cursor than go to next line

DanPatterson_Retired — Sat, 11 Dec 2021 23:49:40 GMT

in fact you don't even need the equality test since it will either be 1 or 0

which equates to a Boolean without the danger of comparing to a number

>>> a = [ not(i%2) for i in range(11)]
>>> b = [ (i%2)== 0 for i in range(11)]
>>> a
[True, False, True, False, True, False, True, False, True, False, True]
>>> b
[True, False, True, False, True, False, True, False, True, False, True]
>>> a == b
True
>>>

Re: Python get two values in a Search Cursor than go to next line

TomSellsted — Thu, 18 Jun 2015 16:09:29 GMT

You are correct sir!

Re: Python get two values in a Search Cursor than go to next line

deleted-user-MS0lE1F_0-sy — Sat, 11 Dec 2021 23:49:43 GMT

Ian/Tom,

I have tried the different versions and it still gets written like this: Anna & I want this: Anna Ben

Ben Charlie Dora

Charlie

Dora

rows = arcpy.SearchCursor(Layer)
textValue = ""
for row in rows:
     count = 1
     if (count%2) == 0:
          textValue += row.getValue(Value1) + '  '
          count += 1
      else:
          textValue += row.getValue(Value) + '\r\n'
          count +=  1
ParcelText2.text = textValue

Re: Python get two values in a Search Cursor than go to next line

TomSellsted — Sat, 11 Dec 2021 23:49:45 GMT

Matthew,

Just a bit of a logic error. This should work:

rows = arcpy.SearchCursor(Layer) 
textValue = ""
count = 1
for row in rows: 
    if (count%2): 
        textValue += row.getValue(Value1) + '  '   
    else: 
        textValue += row.getValue(Value) + '\r\n' 
    count +=  1

ParcelText2.text = textValue

Regards,

Tom

Re: Python get two values in a Search Cursor than go to next line

deleted-user-MS0lE1F_0-sy — Thu, 18 Jun 2015 18:11:50 GMT

Perfect! Thank you all, I love this community, I have learned a lot here.

Re: Python get two values in a Search Cursor than go to next line

TomSellsted — Thu, 18 Jun 2015 18:13:36 GMT

You are welcome!

Re: Python get two values in a Search Cursor than go to next line

IanMurray — Thu, 18 Jun 2015 18:16:38 GMT

Yes, your was set-up for a true first response, while mine was set-up for a false.

Either way, he got what he needed, thanks for the input.

Re: Python get two values in a Search Cursor than go to next line

IanMurray — Thu, 18 Jun 2015 18:27:46 GMT

Matthew,

I wanted to recommend for future using of cursors that you use the new data access cursors(arcpy.da.SearchCursor e.g.). They are significantly faster than the old style cursors you were using in your code. The parameters and syntax are somewhat different from the cursors you were using, but still easy to use.

Here is the link for the new cursors versus old cursors.

ArcGIS Help (10.2, 10.2.1, and 10.2.2)