topic Re: WHAT HAPPENED TO THE ARCVIEW FUNCTIONS LIKE TRIM, EXTRACT, SUBSTITUTE, ETC? HOW CAN I DO THOSE THINGS IN ARCGIS 10.51? in Spatial Data Science Questions

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

lindatomaselli — Mon, 02 Oct 2017 17:49:20 GMT

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.

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

lindatomaselli — Mon, 02 Oct 2017 17:50:02 GMT

oops, I mean 10.51

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

DanPatterson_Retired — Mon, 02 Oct 2017 17:51:41 GMT

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

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

lindatomaselli — Mon, 02 Oct 2017 19:15:08 GMT

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.

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

DanPatterson_Retired — Mon, 02 Oct 2017 19:54:39 GMT

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

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

TedKowal — Tue, 03 Oct 2017 16:29:22 GMT

I am an old vb'r .... hate python but got to go with the changes..... I found this site useful in starting to migrate my scripts over to python.

http://vb2py.sourceforge.net/cgi-bin/convert.py

This is only a short term fix.... but it help move my stuff quickly with little re-writes.

But basic functions are not hard....

Trim

!myField!.strip() or rstrip() or lstrip()

A good useful source I use is Python Reference (The Right Way) - DRAFT — Python Reference (The Right Way) 0.1 documentation

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

RebeccaStrauch__GISP — Tue, 03 Oct 2017 17:52:20 GMT

Alphabetical list of ArcPy functions—Help | ArcGIS Desktop is a good place to start. You can find the functions you used and see sample code for most.

I'm looking for the 'ol functionality equivalent list and will post if I find it. This assumes you are trying to convert AV custom tools to ArcPy. BTW - there are many threads that talk about learning python and ArcPy if you are interested. Do a quick search or one of use can post if you have issues.

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

lindatomaselli — Wed, 04 Oct 2017 14:37:13 GMT

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

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

DanPatterson_Retired — Wed, 04 Oct 2017 15:10:17 GMT

glad it worked out...

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

lindatomaselli — Wed, 04 Oct 2017 16:43:13 GMT

Thanks for your help.

I don’t think I will become proficient in Python any time soon, but eventually I had to learn Avenue, so this may be no different…..until ESRI decides to make another big change to its programming language.

I took a college course on VB and got an “A” but never figured out how to use it with ArcGIS. That training has long been forgotten.

I like to keep things simple so I can pass my models on to other users, but knowing the way to use the old tools from ArcView is very helpful to me.

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

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

RebeccaStrauch__GISP — Wed, 04 Oct 2017 17:08:11 GMT

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.

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

lindatomaselli — Wed, 04 Oct 2017 17:46:15 GMT

Thanks.

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

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

RebeccaStrauch__GISP — Wed, 04 Oct 2017 17:52:58 GMT

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-to-ask-questions-and-get-answers?sr=search&searchId=05e91199-f8dd-4970-babb-3d4a3d555d73&searchIndex=4‌

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-bf8df37a4391&searchIndex=2‌ or https://community.esri.com/people/curtvprice/blog/2014/09/25/posting-code-blocks-in-the-new-geonet?sr=search&searchId=56ba781b-b082-4511-b0c5-0aeffd966a89&searchIndex=4‌ just fyi