nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

FatmaŞenol

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

Earthquake.png

ThematicQueryWidgetDaftSales.zip

pmccord_2-1642557242107.png

Trouver plus de publications taguées avec

Accepted answers

JakeSkinner

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

All comments

FatmaŞenol

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 ?

JakeSkinner

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.

FatmaŞenol

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 ?

FatmaŞenol

Hello Vince,

Please accept my apology for posting to wrong channel.

kenbuja

It has been moved.

JakeSkinner

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

DarrenWiens2

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.

VinceAngelo

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

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.