vba
I'm trying to join one column into another. one is "acct id" and the other is "taxid number". Acct is from one county whereas the tax is from another, so there are blanks in the number of parcels/rows. I did it before last week and I had it written down how to do this.
What I need to do is move 'acct id' into the 'taxid' column. I remember having " " as part of the vb script. What are the steps involved as I keep getting a blank field when I attempt it.
Try something like this:
dim f2
if [field1] = "foo" then
f2 = "bar"
end if
Screen shot of this being used in the field calculator.
Use a static variable to keep track of the incremental value (assuming you're using ArcGIS) in thei field calculator (toggle on the 'advanced' tab)
Static cnt As Integer
Dim startValue as Integer
Dim result as Integer
startValue = 192
cnt = cnt + 1
result = cnt + startValue
then, whateveryourfieldnameis="Pipe-" & result
I think that should work
Best Answer
If you want to move the values in the 'acct id' into the 'taxid' Field, it should be as simple as:
(The field names cannot have a space, so I do not think that 'acct id' is the field name, it should be the field Alias)
If on the other hand, you want to concatinate the strings from both 'acct id' & 'taxid' into a third field, it can be:
if you want a space inbetween them, it hsould be: