topic Re: Does anyone have a method for taking text from one field in an feature class to another field in the same feature class? in ArcGIS Pro Questions

Does anyone have a method for taking text from one field in an feature class to another field in the same feature class?

DanielMesserich — Wed, 22 Apr 2020 22:09:47 GMT

Does anyone have a method for taking text from one field in an feature class to another field in the same feature class? I imported a spreadsheet via FME. After a large number of the points were imported we decided to add a URL path to hyperlink to pdf on a ftp site. The path to the ftp site is located in the description field. I'd like to grab the text including and after the "ftp://..." and copy it to the URL field.

I am not very good at writing scripts so please keep the answers simple for me!

Thanks,

Dan

Re: Does anyone have a method for taking text from one field in an feature class to another field in the same feature class?

RickeyFight — Wed, 22 Apr 2020 22:16:19 GMT

Daniel Messerich‌

Type in "ftp://"+(fieldnamehere) into a calculate field

here is sort of an example below.

How To: Concatenate fields in a table in ArcGIS Pro

Re: Does anyone have a method for taking text from one field in an feature class to another field in the same feature class?

Katie_Clark — Thu, 23 Apr 2020 12:32:29 GMT

Rickey's answer definitely works if the URL is contained neatly in a different field and you just want to add two different fields together. However, based on your question, it sounds like the URL might be contained within a larger paragraph, and you only want to extract certain text from the paragraph to put in the URL field?

If so, I believe Regex (Regular Expressions) or some other more advanced field calculation will be your answer. Are you able to share an example of one of the fields so we can see how it's formatted?