I'm trying to find every instances of an "Avenue #" in the Name field and have Field Calculator copy that over the single letter written in the Subname field so that both fields look exactly the same, but neither python nor visual basic are a strong suit of mine.
I need ONLY the avenue (letter) texts copied. Is there a way to do this with field calculator?
EDIT: Adding this for clarity...
I am needing only the "AVENUE #" text within the NAME field to be copied over to the SUBNAME "#" fields. The results would be an example such as this:
SUBNAME "C" = NAME "Avenue C". But SUBNAME "Avenue Belle Chase" would remain untouched.