query-f18c1988532b743f05c74018435a964a

rq turtle/ttl

title:Using substr to emulate an array PREFIX xsd: http://www.w3.org/2001/XMLSchema# PREFIX fn: http://www.w3.org/2005/xpath-functions#

SELECT ?idx ?num ?num2 (strlen(?arr)/10 AS ?size) WHERE { BIND (CONCAT( "1.11 2.22 3.33 4.44 5.55 ", "6.66 7.77 8.88 9.99 " ) AS ?arr) BIND (2 as ?idx) BIND ((?idx * 10) + 1 AS ?pos) # Blazegraph is fine with whitespace BIND (xsd:decimal(SUBSTR(?arr, ?pos, 10)) AS ?num) # Jena doesn't like whitespace #BIND (xsd:decimal(fn:normalize-space(SUBSTR(?arr, ?pos, 10))) AS ?num2) }

Use at

• https://query.wikidata.org/sparql

#title:Using substr to emulate an array
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX fn: <http://www.w3.org/2005/xpath-functions#>

SELECT ?idx ?num ?num2 (strlen(?arr)/10 AS ?size)
WHERE {
  BIND (CONCAT(
    "1.11      2.22      3.33      4.44      5.55      ",
    "6.66      7.77      8.88      9.99      "
  ) AS ?arr)
  BIND (2 as ?idx)
  BIND ((?idx * 10) + 1 AS ?pos)
  # Blazegraph is fine with whitespace
  BIND (xsd:decimal(SUBSTR(?arr, ?pos, 10)) AS ?num)
  # Jena doesn't like whitespace
  #BIND (xsd:decimal(fn:normalize-space(SUBSTR(?arr, ?pos, 10))) AS ?num2)
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/07