This HTML5 document contains 35 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n4:this

foaf:made

n2:VirtTipsAndTricksGuideSpChar

Subject Item

n10:this

sioc:creator_of

n2:VirtTipsAndTricksGuideSpChar

Subject Item

n20:item

n19:services_of

n2:VirtTipsAndTricksGuideSpChar

Subject Item

n11:this

sioc:creator_of

n2:VirtTipsAndTricksGuideSpChar

Subject Item

n9:VOS

sioc:container_of

n2:VirtTipsAndTricksGuideSpChar

atom:entry

n2:VirtTipsAndTricksGuideSpChar

atom:contains

n2:VirtTipsAndTricksGuideSpChar

Subject Item

n2:VirtTipsAndTricksGuideSpChar

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:37:09.271229

dcterms:modified

2017-06-13T05:37:09.271229

rdfs:label

VirtTipsAndTricksGuideSpChar

foaf:maker

n4:this n8:this

dc:title

VirtTipsAndTricksGuideSpChar

opl:isDescribedUsing

n17:rdf

sioc:has_creator

n10:this n11:this

sioc:content

%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---++How Can I execute SPARQL queries containing '$' character using ISQL? Assuming a SPARQL query should filter on the length of labels: <verbatim> SELECT ?label FROM <http://mygraph.com> WHERE { ?s ?p ?label FILTER(regex(str(?label), "^.{1,256}$") ) } </verbatim> [[http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+%3Flabel%0D%0AWHERE+%0D%0A++%7B+%0D%0A++++%3Fs+%3Fp+%3Flabel%0D%0A++++FILTER%28regex%28str%28%3Flabel%29%2C+%22%5E.%7B1%2C256%7D%24%22%29+%29%0D%0A++%7D+&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=15000&debug=on][View the results]] of the query execution on the [[http://lod.openlinksw.com][LOD]] instance. ISQL uses '$' character as a prefix for macro names of its preprocessor. When '<b>$</b>' character is used in SPARQL query to be executed in ISQL, the character should be replaced with '<b>$$</b>' notation or an escape char + numeric code: <verbatim> SQL> SPARQL SELECT ?label FROM <http://mygraph.com> WHERE { ?s ?p ?label FILTER(REGEX(str(?label), "^.{1,256}$$") ) } </verbatim> [[http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+%3Flabel%0D%0AWHERE+%0D%0A++%7B+%0D%0A++++%3Fs+%3Fp+%3Flabel%0D%0A++++FILTER%28REGEX%28str%28%3Flabel%29%2C+%22%5E.%7B1%2C256%7D%24%24%22%29+%29%0D%0A++%7D+&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=15000&debug=on][View the results]] of the query execution on the [[http://lod.openlinksw.com][LOD]] instance. Note also that the FILTER written in this way, finds <b>?label-s</b> with length less than 256. To achieve fast results, <b>REGEX</b> should be replaced with the <b>bif:length</b> function: <verbatim> SQL> SPARQL SELECT ?label FROM <http://mygraph.com> WHERE { ?s ?p ?label FILTER (bif:length(str(?label))<= 256) } </verbatim> In this way the SPARQL query execution can work much faster if the interoperability is not required and <b>?label-s</b> are numerous. [[http://lod.openlinksw.com/sparql?default-graph-uri=&query=SELECT+%3Flabel%0D%0AWHERE+%0D%0A++%7B+%0D%0A++++%3Fs+%3Fp+%3Flabel%0D%0A++++FILTER+%28bif%3Alength%28str%28%3Flabel%29%29%3C%3D+256%29%0D%0A++%7D+&should-sponge=&format=text%2Fhtml&CXML_redir_for_subjs=121&CXML_redir_for_hrefs=&timeout=15000&debug=on][View the results]] of the query execution on the [[http://lod.openlinksw.com][LOD]] instance. ---+++Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]] * [[http://docs.openlinksw.com/virtuoso/rdfandsparql.html][RDF Data Access and Data Management]]

sioc:id

af0bb8b9aae9159a5eff15f6ec1b675e

sioc:link

n2:VirtTipsAndTricksGuideSpChar

sioc:has_container

n9:VOS

n19:has_services

n20:item

atom:title

VirtTipsAndTricksGuideSpChar

sioc:links_to

n7:VirtTipsAndTricksGuide n12:html n13:on n14:on n23:on n24:com

atom:source

n9:VOS

atom:author

n4:this

atom:published

2017-06-13T05:37:09Z

atom:updated

2017-06-13T05:37:09Z

sioc:topic

n9:VOS