StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>UPDATE</strong>: As the original problem was changed adding the requirement to recognize the word "Spain" not only in all possible capitalizations but also including accented characters, I have updated the solution below so that now "Spain" with <strong>âÂ</strong> and/or <strong>ïÏ</strong> is correctly recognized.</p> <p><strong>Here is a more generic solution than that of @Alejandro</strong>:</p> <p>If we want to select all elements, whose <code>name</code> attribute contains the word "Spain" in any capitalization and if the possible word delimiters are all non-alphabetic characters, then</p> <p><strong>This XPath expression</strong>:</p> <pre><code>/*/*[contains( concat(' ', translate(translate(@name, translate(@name, $vAlpha, ''), ' '), $vUpper, $vLower), ' ' ), ' spain ' ) ] </code></pre> <p><strong>when applied on this XML document</strong>:</p> <pre><code><elements> <element id="1" name="france" /> <element id="2" name="usa" /> <element id="3" name="Spaïn" /> <element id="4" name="france with spâin and africa" /> <element id="5" name="-Spain!" /> <element id="6" name="spain and africa" /> <element id="7" name="italie and Spain." /> </elements> </code></pre> <p><strong>selects the following elements</strong>:</p> <pre><code><element id="3" name="Spaïn"/> <element id="4" name="france with spâin and africa"/> <element id="5" name="-Spain!"/> <element id="6" name="spain and africa"/> <element id="7" name="italie and Spain."/> </code></pre> <p>In the above XPath expression <code>$vLower</code>, <code>$vUpper</code> must be substituted with (respectively):</p> <pre><code>'aaabcdefghiiijklmnopqrstuvwxyz' </code></pre> <p>and</p> <pre><code>'âÂABCDEFGHïÏIJKLMNOPQRSTUVWXYZ' </code></pre> <p><code>$vAlpha</code> must be substituted by the concatenation of <code>$vLower</code> and <code>$vUpper</code> .</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload