2
votes
2answers
1k views

How to convert field values from lower case to upper case in ArcGIS 10.1?

Using the Field Calculator in ArcGIS 10.1, I am able convert the first letter in a value from lower case to upper case. How do you convert the entire value to upper case, though? I can't seem to ...
1
vote
1answer
401 views

How do you calculate a column value based on the value of another column?

I am trying to select data based on whether it starts with certain characters and then update a field. For example if [Asbuilt] starts with "WL" then do something. Here are the two methods I have ...
3
votes
1answer
250 views

Convert ArcMap label expressions from VBScript to Javascript or Python

I have a large number of layers (hundreds) with label expressions written in VBScript. I am using ArcMap 9.3.1, and I'm now starting to export the layers as MPKs for use in our ArcGIS Runtime (WPF) ...
1
vote
2answers
408 views

How to Add Values together using FindLabel (VBscript) function of ArcMap Label Expression?

I'm wanting to add together values from multiple fields in shp file and display the result as a the label here's what I'm looking at right now: if ( [SwineGesBo] + [SwineSowLt] > 0) then output = ...
3
votes
1answer
2k views

Field Calculator VB Script Codeblock IF statement syntax is wrong

I can't figure out why the syntax is wrong in Field Calculator ArcMap 10. The complete codeblock is Dim CapitalDia As Number Dim TwagDia As Number Dim X As Number CapitalDia = [New_Pipe_S] TwagDia ...
4
votes
4answers
1k views

How to concatenate numbers and add in leading zeros?

I have three text fields populated as follows: 1, 9, 1 that I need to concatenate into a field that looks like 01.09.01. Getting to 1.9.1 is easy but can anyone help out with how to formulate it so ...
3
votes
1answer
621 views

VBscript Regular Expression in ArcMap Field Calculator

I'm looking for a regex in VBscript that I can use on a ArcMap table. I know what it would look like in python: pat =r'[0-9]{3,4}' This filters all numeric characters from the string which have the ...
6
votes
1answer
453 views

ArcMap 10: How do I escape certain characters when labeling?

I am labeling certain Oil & Gas areas by Operator in ArcMap 10, using this expression: "" & [OPERATOR] & "" & vbNewline & "" & [UNIT_NAME] & "" The only problem is ...
1
vote
3answers
1k views

Using VBScript to label shapefile in ArcMap

If you're reading this for the first time, it might be best to focus on section beneath ANOTHER UPDATE. I'm a beginner with VBScript and I have a question about using an VBScript expression for a ...
3
votes
1answer
4k views

How to sort a feature class and then calculate a sequential ID field?

I am in ArcMap and I want to sort the records based on a field and then do a Calculate Field with an auto-incrementing value with the sort in-place. Any ideas? It looks like I could get an update ...