Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Would this be ok to use them for the field calculator in ArcGIS 9.3 ? See here MS Excel VBA Functions

Or should I fix them in MS Excel and save as a file and then use the join with the shapefile or file geodatabase. Will this work ? Will ArcGIS read it in table ?

Please advice as I am looking for information on how to use field calculator.

Thanks

share|improve this question
3  
Some of those functions are built-in to VBA, some are specific to Excel. For examples of VBA functions available in the field calculator see: support.esri.com/en/knowledgebase/techarticles/detail/31807 –  blah238 Oct 18 '11 at 2:47
    
Can anyone tell me how to use it to force the decimals remove and replace with the comma. Here I have a column with acres like this 506320.0750 and I want this (506,320) to display permanmently ? –  PROBERT Oct 18 '11 at 18:39
    
Please ask a separate question for this. –  blah238 Oct 18 '11 at 19:00
    
I posted in a separate question. –  PROBERT Oct 18 '11 at 19:20
add comment

2 Answers 2

up vote 4 down vote accepted

Here is a technical document describing some of the basic VBA calculator functions, with links to some short walk-throughs. And here is some narrative (with examples) on using the Field Calculator and VBA.

Remember that using VBA in the field calculator is only valid for 9.3.1 and not 10 (which uses python and VBScript).

share|improve this answer
add comment

You can open field calculator and use a function like...
ltrim [my_field]
Then in field calculator you will see a save button.
This will save a file that can be reloaded in caclulator.
You can view this file in notepad (or other text editor).
As blah238 said the knowledgebase article will help show what can and can't be used.

NOTE: You will only be able to use field calculator on the left side of your join (unless you create a dbf file with an oid and join that).
Esri join
Calculations
Examples

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.