How to remove period, comma, symbols using field calculator?

Question

I want to delete . , # in attribute table using field calculator (VB Script or Python).

How can I remove these using this example address: N. First St., Unit #1 (I don't need city or state name)

I checked several websites, but I couldn't find the clear answer.

Which field calculator are you using? ArcGIS for Desktop, QGIS and probably other GIS software have this tool. — PolyGeo, Apr 01 '15 at 20:39

score 3 · Answer 1 · answered Apr 01 '15 at 21:44

3

Use the built-in str.translate(table[, deletechars]), but with None for the table argument (requires at least Python 2.6). E.g.:

'N. First St., Unit #1'.translate(None, '.,#')

shows:

'N First St Unit 1'

Or for ArcGIS' calculator, this can be a one-liner:

!yourField!.translate(None, '.,#')

answered Apr 01 '15 at 21:44

Mike T

score 1 · Answer 2 · answered Apr 01 '15 at 20:52

1

Use python to calculate values in new field:

filter(lambda x: x not in ".,#", !yourField!)

answered Apr 01 '15 at 20:52

FelixIP

score 1 · Answer 3 · answered Apr 01 '15 at 20:56

1

in the python code block:

import re

def strip(value):
    return re.sub('[.,#]','',value)

and then in the field calculator:

strip(!fieldname!)

answered Apr 01 '15 at 20:56

jmcbroom

score 1 · Answer 4 · answered Apr 01 '15 at 21:33

1

And another way.

Python Pre-Logic Script Code:

def remove(text):
    for char in [".", ",", "#"]:
        if char in text:
            text = text.replace(char, "")
    return str(text)

Bottom part:

remove(!yourField!)

answered Apr 01 '15 at 21:33

ianbroad

4 Answers4