%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}% ---++How Do I Clean Up Errant Data using SPARQL Update Language? ---+++What? Cleaning up errant data using SPARQL Update Language. ---+++Why? All data endeavors involve varying degrees of prospective and retrospective error correction. ---+++How? 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: DELETE FROM { `iri("http://isbsg.clearbluewater.com.au/wsf/datasets/378/Capers Jones_107_12122011081257")` a }; ---+++Related * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]