arcgis-10.0arcgis-desktopfield-calculatorvbscript
I am trying to do the following in the field calculator in ArcGIS 10
if [IncdStDir] = " " then [IncdStNo] &" " & [IncdStName] &" " & [IncdStSfx]
else [IncdStNo] &" " & [IncdStDir]&" " & [IncdStName] &" " & [IncdStSfx]
end if
I keep getting an error when I try to run this. I am new to Vb.
Here's a solution that should work. It also uses the UCase function that will convert your text to uppercase, so you don't have to check for all variants
dim output
if InStr(UCase( [Export_Output.std]), "LORAIN") > 0 then
output = 1
else
output = 0
end if
You'll also put "output" into the lower box
EDIT
Here's another test using joined data like in your original case.
Yes and no. You can create fields from a standalone VBScript, but not within Field Calculator. See link below for how to write VBScript:
Creating the geoprocessor object
I would recommend learning and using python instead for the task that you are trying to do. You could use a SearchCursor to search for the field values, then add your fields based on the SearchCursor result and then calculate.
Best Answer
Updated code as @Russell Mercer suggested.
Make sure you have the advanced checkbox checked and are calculating on the field you want the result posted to. Try this:
And include output variable in the Prelogic section.