Select to view content in your preferred language

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

861
2
04-22-2020 03:09 PM
DanielMesserich
Emerging Contributor

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

Tags (1)
0 Kudos
2 Replies
RickeyFight
MVP Regular Contributor

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 

0 Kudos
Katie_Clark
MVP Alum

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? 

Best,
Katie

If this answer helped you, please consider giving a kudos and/or marking as the accepted solution. Thanks!
0 Kudos