AnsweredAssumed Answered

Convert VB to Python, Help?

Question asked by Tomsriv on Aug 3, 2017
Latest reply on Aug 22, 2017 by Tomsriv

Hi all, I am new to Python and trying to make an older piece of code work.  It takes two tables, compares them, and if data in table A doesn't match table B it overwrites A with B. 

If they are equal it leaves them alone...

 

dim intval

if [STR_NUM] = [SITUS_NR] then

intval = " "

else

intval = [STR_NUM]

end if

 

If it finds a "nil" in a field in table B it clears the field in table A

 

dim intval

if [STR_NUM] = "nil" then

intval = " "

else

intval = [SITUS_NR]

end if

 

Finally it overwrites table A if it finds data in table B

 

dim intval

if [STR_NUM] <> " " and [STR_NUM] <> "nil" then

intval = [STR_NUM]

else

intval = [SITUS_NR]

end if

 

Can anyone help me convert these or at least one to Python?

Thank you!

Outcomes