<docbook><section><title>VirtTipsAndTricksGuideCleanErrantData</title><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h2">How Do I Clean Up Errant Data using SPARQL Update Language?</bridgehead>
<para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">What?</bridgehead>
 Cleaning up errant data using SPARQL Update Language.<bridgehead class="http://www.w3.org/1999/xhtml:h3">Why?</bridgehead>
 All data endeavors involve varying degrees of prospective and retrospective error correction.<para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">How?</bridgehead>
 Given a triple in a Virtuoso Quad store that contains an errant URI e.g.
 one that accidentally contains spaces, here is a SPARQL example that showcases how to delete said triple using a built-in function:<programlisting>DELETE FROM &lt;your_graph&gt; 
  { 
    `iri(&quot;http://isbsg.clearbluewater.com.au/wsf/datasets/378/Capers Jones_107_12122011081257&quot;)` 
     a &lt;http://isbsg.org/ontology/data/Dataset&gt;  
  };
</programlisting><para> </para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">Related</bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="VirtTipsAndTricksGuide">Virtuoso Tips and Tricks Collection</ulink> </listitem>
</itemizedlist></section></docbook>