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

Question

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

Katie_Clark · Answer

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?

RickeyFight · Answer

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