Latest Contributions by JoshuaSharp-Heward

That really should run fine, I don't see how that's giving a syntax error, unless it doesn't like the indentation. In any case I defer to Dan's solution which is running the same thing but in one line: !NADR_ID! if !NADR_ID! in !ABOVE! else None ... View more

Can you post another picture of what you ran this time? ... View more

So in the original code I sent through, leave the field1 and field2 as they are (don't replace with your fields)! When you run myfunct(!NADR_GID!, !ABOVE!) that's substituting those values in there. ... View more

This shouldn't be an issue from my understanding, the multiple numbers in the second column are all just strings joined by ";"s, so if the number from the first column is anywhere in the second column it will return it. Have you tried running it? If so maybe you can show me where it has returned a value that you didn't want? ... View more

Hi Kristyna, I've done something quite similar to this in the past! In this case you don't actually need to use cursors, just the field calculator using Python will do! If you right click on the third field (BELOW) and go to "calculate field", select "python" for the expression type, put the following code in the code block: def myfunc ( field1 , field2 ) : if str ( field1 ) in field2 : return field1 else : return None ‍ ‍ ‍ ‍ ‍ Then in the box above the codeblock, put the following line my_func ( !NADR_GID! , !ABOVE! ) ‍ ‍ It should do exactly what you're hoping for it to do. Basically taking the first number, converting it to a string, looking for that sequence in the second field, then returning the first field's value if there is a match! ... View more