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; } } }

Selection in ArcGIS Pro

JoeBorgione

Pro 2.4

Probably missing something painfully obvious but....

In arc gis pro, I want to select a field where the value begins with A-Z, so I create a clause like this:

but the results look like this:

I've got street names that start with A-Z as well as 1-9; how do I create an expression that gives me the results I'm after?

Find more posts tagged with

Accepted answers

bixb0012

Joe, now I see what you are pointing out. File geodatabases don't support regular expression features using LIKE, you have to use SIMILAR TO. See /blogs/tilting/2018/07/19/like-and-similar-file-geodatabases-and-pattern-matching. What you want in Pro with file geodatabases is:

StreetName SIMILAR TO '[A-Z]%'

All comments

JoeBorgione

I just have the 'thing' with Pro. I try something that is fairly routine and when it doesn't work I'm amused....

bixb0012

Joe, if you have expressions that work and you can manually put the SQL in, why are you wanting to only use the Pro SQL builder?

DanPatterson_Retired

No it doesn't, Try <=Z. I don't have anything see any sql thingy where you can slice the first character of the record and do an IN check.

Like this easy python test and return

a <SPAN class="operator token">=</SPAN> <SPAN class="string token">'abcd1fAb2gh3'</SPAN>
<SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> a <SPAN class="keyword token">if</SPAN> i <SPAN class="keyword token">in</SPAN> string<SPAN class="punctuation token">.</SPAN>ascii_letters<SPAN class="punctuation token">]</SPAN>
<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'c'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'d'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'f'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'g'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'h'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JoeBorgione

You mean [A-Z] works for you? Here's the dropdown I get:

In a SQL window I can go old school and get the numeric streets this way:

and named streets with:

But I was hoping to save the whales, feed the children, and end nuclear proliferation with built in Pro functionality..... Maybe next week....

DanPatterson_Retired

I can't replicate you [A-Z] what other options are there in the drop-down list beside it? maybe a NOT [1-9]

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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