POST
|
First of all, thanks everyone for the suggestions. I tried a few and they really didn't make the task seem any easier. So I did some more digging and found this webpage on another forum http://stackoverflow.com/questions/6266727/python-cut-off-the-last-word-of-a-sentence I modified the python statement a bit, but then had to edit MyField so that the UNIT, or BLDG, or whatever had only these words and a unit number also only one word. So two words at the end of the test string separated by spaces. I selected only the strings in MyField that matched this last two word standard and then using Field Calculator (and the Python radio button where the original statement is listed in the String Function list) this is what I put in for MyField = !MyField!.rsplit(' ', 2)[0] And that worked. So still no idea how to express a wildcard in Find and Replace, but now I am able to match my addresses without the pesky UNITS, BLDGS, etc. Have a great week everyone!
... View more
04-04-2016
03:23 PM
|
0
|
0
|
1887
|
POST
|
Is there a wildcard I can use in Find and Replace so that I can get rid of things like 'BLDG 7', or 'UNIT A' from the end of addresses. I am trying to match addresses to an address file that does not include the Unit numbers of BLDG numbers. Is there a way to eliminate these types of details from the end of this text string? I can find them with Select by Attributes where (MyTableName) LIKE '% BLDG %' brings back the records, but in the table I am working on this brings back 1752 records and that is way too many to hand correct...
... View more
03-30-2016
05:35 PM
|
0
|
7
|
9124
|
POST
|
Mark, Have you tried the Copy Features tool? You can find the tool in ArcToolbox > Data Management Tools > Features Make the new Feature first, then add new fields to this table, join your table to this new feature class table (you may need to make table views and/or add attribute indexes to get it to work without error messages) and then calculate the values from your joined table fields to the table fields on your new feature. I hope this works for you Peter
... View more
03-10-2015
10:49 AM
|
1
|
1
|
2814
|
Title | Kudos | Posted |
---|---|---|
1 | 03-10-2015 10:49 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:25 AM
|