topic Re: VB conditional statement not working in calculate field tool in Python Questions https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153640#M11869 <HTML><HEAD></HEAD><BODY><SPAN>Great post, perfect solution that saved me hours of head scratching. Thanks for taking the time to post the solution.</SPAN><BR /><BR /><SPAN>Paulg</SPAN></BODY></HTML> Wed, 06 Jul 2011 13:23:17 GMT PaulGrimes 2011-07-06T13:23:17Z VB conditional statement not working in calculate field tool https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153636#M11865 <HTML><HEAD></HEAD><BODY><SPAN>I am writing a python script which utilizes the expression &amp; code block parameter in the calculate field tool to populate values for a specific field. The code block uses a conditional If,Then, Else statement to understand the value of an existing field (Num_Value) in order to calculate the value of another field (Num_Text). However, I keep receiving the error "(Microsoft VBScript compilation error) Expected end of statement". See script below:</SPAN><BR /><SPAN>...</SPAN><BR /><SPAN>CodeBlock = "dim X as string \\nIf [Num_Value] = 1 Then \\nX = \"Poor\" \\nElse X = \"Good\" \\nEnd If"</SPAN><BR /><SPAN>gp.CalculateField_management(InputFeature,"Num_Text","X","VB",CodeBlock)</SPAN><BR /><SPAN>...</SPAN><BR /><BR /><SPAN>Any ideas as to what I am doing wrong within the VB code block??</SPAN><BR /><SPAN>Any help is greatly appreciated!</SPAN><BR /><SPAN>Thanks!</SPAN><BR /><BR /><SPAN>P.S. Using arcmap 9.2</SPAN></BODY></HTML> Tue, 24 May 2011 16:11:20 GMT https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153636#M11865 CrystalCarreon 2011-05-24T16:11:20Z Re: VB conditional statement not working in calculate field tool https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153637#M11866 <HTML><HEAD></HEAD><BODY><SPAN>I using ArcGIS 10, so I can't test this. But, in 10 you can use VBScript for the code block (although I'm not completely sure what 9.2 uses - the help says standard VB). I know that VBScript doesn't like it when you dim variables AS a datatype. I suggest either not dimming your variable, or at least remove "as string".</SPAN></BODY></HTML> Tue, 24 May 2011 18:03:27 GMT https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153637#M11866 DarrenWiens2 2011-05-24T18:03:27Z Re: VB conditional statement not working in calculate field tool https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153638#M11867 <HTML><HEAD></HEAD><BODY><SPAN>That did the trick! Thanks so much!</SPAN><BR /><BR /><SPAN>When I used that bit of code just within ArcMap it worked fine so I figured I would include it but I guess not!</SPAN><BR /><BR /><SPAN>Thanks again!</SPAN></BODY></HTML> Tue, 24 May 2011 18:26:31 GMT https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153638#M11867 CrystalCarreon 2011-05-24T18:26:31Z Re: VB conditional statement not working in calculate field tool https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153639#M11868 <HTML><HEAD></HEAD><BODY><SPAN>No problem - I've spent a lot of time tilting at that windmill in the past!</SPAN></BODY></HTML> Tue, 24 May 2011 18:57:03 GMT https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153639#M11868 DarrenWiens2 2011-05-24T18:57:03Z Re: VB conditional statement not working in calculate field tool https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153640#M11869 <HTML><HEAD></HEAD><BODY><SPAN>Great post, perfect solution that saved me hours of head scratching. Thanks for taking the time to post the solution.</SPAN><BR /><BR /><SPAN>Paulg</SPAN></BODY></HTML> Wed, 06 Jul 2011 13:23:17 GMT https://community.esri.com/t5/python-questions/vb-conditional-statement-not-working-in-calculate/m-p/153640#M11869 PaulGrimes 2011-07-06T13:23:17Z