Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
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.
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:
Dim output
if [IncdStDir] = " " then
output = [IncdStNo] & " " & [IncdStName] & " " & [IncdStSfx]
else
output = [IncdStNo] & " " & [IncdStDir] & " " & [IncdStName] & " " & [IncdStSfx]
end if
And include output variable in the Prelogic section.
& " " instead of &" ") to see if that helps. As long as all of those columns actually exist in the layer, nothing else looks wrong.
Jun 30, 2011 at 16:52
Your Else clause doesn't have an = sign. You're not setting anything there, just concatenating fields. You need to set a value, call a function, or do something (technically you could leave the else clause blank, but that would be pointless). Just concatenating fields without setting a variable to them isn't a valid statement within the clause.
You said you "put the Dimo output as string in the Pre-logic section and then I copied your text in to the other section". This is not correct for the field calculator.
Paste all of the code from "Dim output..." to "...End If" in the Pre-logic section. The only text in the other section should be output.
