topic Remove parentheses from data using field calculator. in Python Questions

Remove parentheses from data using field calculator.

TerryMergl — Tue, 16 Jan 2018 14:32:54 GMT

Good morning.

I am not real savvy with field calculator. We have a couple fields that contain service address information. Someone opted to add additional information enclosed by parentheses in this field. I need to remove the parentheses and data within. Any advice or suggestions appreciated.

Thanks

Terry

Re: Remove parentheses from data using field calculator.

RobertScheitlin__GISP — Tue, 16 Jan 2018 14:43:06 GMT

Terry,

Using VBScript in the field calculator you just use Mid([yourfieldname], 1, (InStr([yourfieldname],"(") - 1))

This will look in the thread for the first occurance of "(" and take everything before the "(" and use it for the field calc.

Re: Remove parentheses from data using field calculator.

DanPatterson_Retired — Sat, 11 Dec 2021 17:35:59 GMT

Terry a little function for the field calculator

Python parser of course

expression box .... brace(!YourFieldNameHere!)

code block

def brace(fld):
    """replace brackets"""
    a = ['[', ']', '{', '}', '(', ')']
    for i in a:
        fld = fld.replace(i, "")
    return fld‍‍‍‍‍‍

of course you are putting the result in a new text field of appropriate width

Re: Remove parentheses from data using field calculator.

RobertScheitlin__GISP — Tue, 16 Jan 2018 15:05:22 GMT

Dan,

What about the data within?

I need to remove the parentheses and data within

Re: Remove parentheses from data using field calculator.

TerryMergl — Tue, 16 Jan 2018 15:18:09 GMT

Thank you Robert. I'll give it a shot.

Re: Remove parentheses from data using field calculator.

TerryMergl — Tue, 16 Jan 2018 15:19:55 GMT

Thank you Dan.

What happened is when the service address got populated, someone added additional info between the parentheses in the same field, rather than using an address2 field

I don't need to save that info, just remove it.

Thank you

Re: Remove parentheses from data using field calculator.

DanPatterson_Retired — Tue, 16 Jan 2018 15:41:04 GMT

ahh missed that bit

Re: Remove parentheses from data using field calculator.

DanPatterson_Retired — Sat, 11 Dec 2021 17:36:02 GMT

well the other function you might use.... but

Keep between the brackets

fld = "some stuff (the stuff) with more"

fld.split(")")[0].split("(")[1]

# yields

'the stuff'

# just replace fld with !YourFieldName!
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Dump between the brackets

fld = "some stuff (the stuff) with more"

fld.split("(")[0].strip() + fld.split(")")[1]

'some stuff with more'‍‍‍‍‍

Re: Remove parentheses from data using field calculator.

JamesMacKay3 — Tue, 16 Jan 2018 16:53:41 GMT

Using the Python interpreter, import the regular expression module (re) in the pre-logic script code block (click on Show Codeblock to open this):

import re‍

Then use a substitution along the lines of this:

re.sub(r"\([^\)]+\)", "", !ServiceAddr!)‍

Should work fine with multiple pairs of parentheses but will likely need to be tweaked if you've got nested pairs.

Re: Remove parentheses from data using field calculator.

DanPatterson_Retired — Tue, 16 Jan 2018 16:57:25 GMT

you missed the bit I did earlier... the stuff between the braces needs to be removed as well

Re: Remove parentheses from data using field calculator.

RobertScheitlin__GISP — Tue, 16 Jan 2018 17:11:12 GMT

Dan,

Actually James's regex gets all the string(s) between the ()s. RegEx is very powerful for stuff like this.

Re: Remove parentheses from data using field calculator.

DanPatterson_Retired — Tue, 16 Jan 2018 17:15:18 GMT

yes, I used to use them, but they changed in python 3.x so I just lost track of what applied to where