Hi Ian, You can escape with the “\” character both for insert/update and delete ie “EAME\\L300641” …
Hughs-MBP-2:~ hwilliams$ isql 1111
Connected to OpenLink Virtuoso
Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> SPARQL INSERT DATA { GRAPH <http://example.com/core/graph/data> { <a>
<http://www.w3.org/2008/05/skos-xl#literalForm> "EAME\\L300641" } };
Done. -- 10 msec.
SQL> SPARQL SELECT * FROM <http://example.com/core/graph/data> where {?s ?p ?o};
s
p
o
LONG VARCHAR
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
a
http://www.w3.org/2008/05/skos-xl#literalForm
EAME\L300641
1 Rows. -- 14 msec.
SQL>
Hughs-MBP-2:~ hwilliams$ isql 1111 dba dba exec='SPARQL WITH
<http://example.com/core/graph/data> DELETE { <a>
<http://www.w3.org/2008/05/skos-xl#literalForm> "EAME\\L300641" }'
Connected to OpenLink Virtuoso
Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
Done. -- 1 msec.
Hughs-MBP-2:~ hwilliams$ isql 1111
Connected to OpenLink Virtuoso
Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> SPARQL SELECT * FROM <http://example.com/core/graph/data> where {?s ?p ?o};
s
p
o
LONG VARCHAR
LONG VARCHAR
LONG VARCHAR
_______________________________________________________________________________
0 Rows. -- 1 msec.
SQL>
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 13 Dec 2016, at 09:34, Ian Harrison <[email protected]> wrote:
>
> I have a situation where I want to do a delete of a large number of
> triples, some of which have escape characters in a literal
>
> So my question is 2 fold.
>
> 1) Is there a bulk delete procedure, equivalent to the bulk upload?
> 2) If I delete, via isql, on a per triple basis, how can I do so with
> triples like this:
>
> <x> <http://www.w3.org/2008/05/skos-xl#literalForm> "EAME\L300641"
>
> I'm trying to do via the ISQL interface in a bash script
>
> i.e. /apps/virtuoso/bin/isql 1111 dba dba exec='SPARQL WITH
> <http://example.com/core/graph/data> DELETE { <x>
> <http://www.w3.org/2008/05/skos-xl#literalForm> "EAME\L300641" }'
>
> The error I get is - Bad escape sequence in a SPARQL short double-quoted
> string --- issue is the \
>
> I get the same with a triple like
>
> <y> <http://www.w3.org/2004/02/skos/core#prefLabel> "10%w/w solution of
> Marlox"; -- is is the %
>
> Is there some way via isql in a bash script to get characters like \ and
> % escaped?
>
> Thanks
>
> Ian
>
> --
> Ian Harrison Email: [email protected]
> Tel: +44 (0)7580 618125
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
