topic Re: How to select a word between parenthesis in a attribute table ? in Data Management Questions

How to select a word between parenthesis in a attribute table ?

FatmaŞenol — Thu, 07 May 2015 19:53:13 GMT

Dear members,

I have a quick question and hope if you could kindly share your suggestions.

I'm trying to select words between parenthesis (i.e (Izmir). I've searched Geonet

for this specific task but ended up with no luck. I'm sending the screenshot

of the table. Thank you in advance.

Regards

Re: How to select a word between parenthesis in a attribute table ?

VinceAngelo — Thu, 07 May 2015 20:01:33 GMT

This forum is for help with GeoNet itself. In order to move this question to the correct forum you'll need to specify what Esri product you are using, the release of that product, and the programming language you are using.

- V

Re: How to select a word between parenthesis in a attribute table ?

DarrenWiens2 — Thu, 07 May 2015 20:02:19 GMT

edit: the following is to extract the word between parentheses. If you are looking to simply select features based on the word between parentheses, follow Jake's advice below.

Using Python in field calculator:

!Place!.split('(')[1].split(')')[0]

Basically, split your original string by the character '(', take the second part of that, split it by ')', and take the first part of that.

Re: How to select a word between parenthesis in a attribute table ?

JakeSkinner — Thu, 07 May 2015 20:03:25 GMT

Hi Omur,

You can accomplish this using a wildcard. For example, to do this with a feature class:

Place LIKE '%(Izmir)%'

See the section 'Search Strings' in the below link:

Building a query expression—Help | ArcGIS for Desktop

Re: How to select a word between parenthesis in a attribute table ?

KenBuja — Thu, 07 May 2015 20:03:56 GMT

It has been moved.

Re: How to select a word between parenthesis in a attribute table ?

FatmaŞenol — Thu, 07 May 2015 20:27:46 GMT

Hello Vince,

Please accept my apology for posting to wrong channel.

Re: How to select a word between parenthesis in a attribute table ?

FatmaŞenol — Thu, 07 May 2015 20:36:19 GMT

Hello Jake,

Thank you for your suggestion. It worked . After I posted my original question I realized

that I also need to copy the words between the parenthesis to a new field. Could it be done

using Field Calculator ?

Re: How to select a word between parenthesis in a attribute table ?

JakeSkinner — Thu, 07 May 2015 20:42:25 GMT

Yes, after you make the selection use the syntax Darren specified in the field calculator.

!Place!.split('(')[1].split(')')[0]

Be sure to check 'Python' at the top of the Field Calculator.

Re: How to select a word between parenthesis in a attribute table ?

FatmaŞenol — Thu, 07 May 2015 21:04:28 GMT

Hi Jake,

Thank you for your help. I just have one more question. How can I

copy all the words between parenthesis not only the selected records ?

Re: How to select a word between parenthesis in a attribute table ?

JakeSkinner — Fri, 08 May 2015 10:41:07 GMT

You can do this by not having any features selected and using a try/except statement since not all of the rows contain values with parentheses. Ex:

It will try the code, but if the row does not contain any parentheses, it will pass this row rather than creating an error.