WHAT HAPPENED TO THE ARCVIEW FUNCTIONS LIKE TRIM, EXTRACT, SUBSTITUTE, ETC? HOW CAN I DO THOSE THINGS IN ARCGIS 10.51?

[lindatomaselli]

I used to use all sorts of neat tools when calculating, such as trim, extract, left right, substitute, etc.  What happened to these?  I want to use them in ArcGIS 19.51.

[lindatomaselli]

oops, I mean 10.51

[DanPatterson_Retired]

They are field calculator options when the vb option is used.  You should get used to python and its similar functionality.  BTS those options will be available in either incarnation when a Text field is selected and not any other field type

[lindatomaselli]

Where can I find the syntax, and "how to" instructions?  There is nothing in the help files.  I am frustrated because it was so easy to use in ArcView.

[DanPatterson_Retired · Accepted solution]

same principles... have a start with the help file topics

http://pro.arcgis.com/en/pro-app/help/data/tables/fundamentals-of-field-calculations.htm

http://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field-examples.htm

there are many more in there

[lindatomaselli]

Thank you very much.

I finally figured out how to do it. It was so simple, with a bit of help from outside sources. I just needed to select the python option in calculate, which automatically surrounded the field in !!, and then followed the syntax that I learned.

This was a big frustration for me, so this was a big advancement in my knowledge.

I am a very intense, but basic user, and I have resisted the need to learn Python. GIS used to be more simple. I guess I am a dinosaur… my experience goes all the way back to PC ArcInfo and writing SML’s.

I might add, I was looking for a simple example like:

BLOCKID =

!BLOCKID!.replace("17113","99999").

Again, thank you for steering me in the right direction.

Dr. Linda Tomaselli, GISRDC

341 Jamaica Way

Niceville, FL 32578

(850) 687-6459 or (850) 897-2012

<mailto:Ltomaselli@GISRDC.com> Ltomaselli@GISRDC.com or <mailto:Ltomaselli@Earthlink.net> Ltomaselli@Earthlink.net

[DanPatterson_Retired]

glad it worked out... 

[RebeccaStrauch__GISP]

Glad you got it worked out.  I am also one of the dinosaurs from back in the ArcINFO Workstation and AML days.  Python, in my opinion, was the first good substitute for scripts I wrote on AML.  So give it a chance.  With all the samples in the help doc, (and here in the Geonet community), you may really like it.

In any case, remember to mark comments in the thread as helpful, and one as correct....or at least "assumed answer" so the thread will be closed.  Happy GISing.

[lindatomaselli]

Thanks.

I am not sure how to close the thread. I don’t see a place to do it on the site.

[RebeccaStrauch__GISP]

If you are doing if thru the email, it doesn't have an option  You will need to open it in a browser.  Then there should be a place to mark on of the answers as correct.....or in the original post, there should be an "assumed answered" if nothing answered it for you.  Hope that helps.

A good blog to look at, for future reference...  https://community.esri.com/community/help-and-feedback/blog/2016/08/15/community-news-and-tips-how-t...‌ 

And if you end up needing to post code in the future /blogs/dan_patterson/2016/08/14/script-formatting?sr=search&searchId=0171eb4c-8db7-4ffc-b945-bf8df37...‌  or https://community.esri.com/people/curtvprice/blog/2014/09/25/posting-code-blocks-in-the-new-geonet?s...‌  just fyi