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 add quotes around items in a List.

deleted-user-yC5VkbyXzrQR

How do I put quotes around the items in the variable ?

b <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'23'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'25'</SPAN><SPAN class="punctuation token">]</SPAN>
a <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'003'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'030'</SPAN><SPAN class="punctuation token">]</SPAN>


sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} IN ({}) AND {} IN ({})"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"STATE_CODE"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">", "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>str<SPAN class="punctuation token">(</SPAN>m<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> m <SPAN class="keyword token">in</SPAN> b<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CNTY_CODE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">", "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>str<SPAN class="punctuation token">(</SPAN>n<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> n <SPAN class="keyword token">in</SPAN> a<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

It will spit out something like this

'STATE_CODE IN (23, 25) AND CNTY_CODE IN (003, 030)'

I need the quotes around the numbers. mapping.DefintionQuery does not like the zeros for some reason. I believe its because there's no quotes around the number.

So I need it to look like below.

SQL = "STATE_CODE IN ('23', '25') AND CNTY_CODE IN ('003', '030')"

Thanks

Find more posts tagged with

Accepted answers

All comments

DanPatterson_Retired

like this?

sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} IN ({}) AND {!s:} IN ({!s:})"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"STATE_CODE"</SPAN><SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CNTY_CODE"</SPAN><SPAN class="punctuation token">,</SPAN>  a<SPAN class="punctuation token">)</SPAN>

sql
<SPAN class="string token">"STATE_CODE IN (['23', '25']) AND CNTY_CODE IN (['003', '030'])"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

or like this?

sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} IN ('{}', '{}') AND {} IN ('{}', '{}')"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"STATE_CODE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">*</SPAN>b<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CNTY_CODE"</SPAN><SPAN class="punctuation token">,</SPAN>  <SPAN class="operator token">*</SPAN>a<SPAN class="punctuation token">)</SPAN>

sql
<SPAN class="string token">"STATE_CODE IN ('23', '25') AND CNTY_CODE IN ('003', '030')"</SPAN>‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

or perhaps specify what the string should look like when complete

deleted-user-yC5VkbyXzrQR

Hey Dan thanks for the reply.

The problem with the first one is that the SQL expression doesn't like the [ ] brackets around the results. Could i do a remove "[" "]" from the string or something like that. ?

The problem with the second one is that, the list can have more than 2 variables, it can have say from 1 - 15. So the list length will change each time.

"or perhaps specify what the string should look like when complete "I'm not sure how to do this.

DanPatterson_Retired

tuple your list

b <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'23'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'25'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'27'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'29'</SPAN><SPAN class="punctuation token">]</SPAN>
a <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'003'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'030'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'300'</SPAN><SPAN class="punctuation token">]</SPAN>

sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{} IN {} AND {!s:} IN {!s:}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"STATE_CODE"</SPAN><SPAN class="punctuation token">,</SPAN> tuple<SPAN class="punctuation token">(</SPAN>b<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CNTY_CODE"</SPAN><SPAN class="punctuation token">,</SPAN>  tuple<SPAN class="punctuation token">(</SPAN>a<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

sql

 <SPAN class="string token">"STATE_CODE IN ('23', '25', '27', '29') AND CNTY_CODE IN ('003', '030', '300')"</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

deleted-user-yC5VkbyXzrQR

Hey Dan thanks for the help. We ended up with a script like below. I realized that the SQL query was not right doing it the above way.

li2 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'153'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'043'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'003'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'093'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'151'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'047'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'011'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'50'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'073'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
 <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'50'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'099'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
lst_fips <SPAN class="operator token">=</SPAN> li2

length <SPAN class="operator token">=</SPAN> len<SPAN class="punctuation token">(</SPAN>lst_fips<SPAN class="punctuation token">)</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN>
output <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
<SPAN class="comment token">#iterate through list and format output</SPAN>
index <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN> 
<SPAN class="keyword token">for</SPAN> i<SPAN class="punctuation token">,</SPAN>j <SPAN class="keyword token">in</SPAN> lst_fips<SPAN class="punctuation token">:</SPAN>   
    state_code <SPAN class="operator token">=</SPAN> <SPAN class="string token">'(\''</SPAN><SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN><SPAN class="string token">'\')'</SPAN>
    county_code <SPAN class="operator token">=</SPAN> <SPAN class="string token">'(\''</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>j<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\')'</SPAN>
    sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"(STATE_CODE IN {} AND CNTY_CODE IN {})"</SPAN>
    <SPAN class="keyword token">if</SPAN> index <SPAN class="operator token"><</SPAN> length<SPAN class="punctuation token">:</SPAN>
        output <SPAN class="operator token">=</SPAN> output <SPAN class="operator token">+</SPAN> sql<SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>state_code<SPAN class="punctuation token">,</SPAN> county_code<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" OR "</SPAN>
        index <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        output <SPAN class="operator token">=</SPAN> output <SPAN class="operator token">+</SPAN> sql<SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>state_code<SPAN class="punctuation token">,</SPAN> county_code<SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>output<SPAN class="punctuation token">)</SPAN> 
<SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'153'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'043'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'003'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'093'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'151'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'047'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'40'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'011'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'50'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'073'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> OR <SPAN class="punctuation token">(</SPAN>STATE_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'50'</SPAN><SPAN class="punctuation token">)</SPAN> AND CNTY_CODE IN <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'099'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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.