[Virtuoso-users] using isql with unix console

Sebastian Hellmann Thu, 24 Jun 2010 07:19:58 +0000

Hello,
I'm having trouble getting the data out of Virtuoso on a unix console.

I can not use "cut" because isql pretty prints out whitespace in betweenresult columns instead of tabs.

An example:
FILE test.isql :
###################
sparql SELECT ?s ?o
FROM <http://dbpedia.org>
{ ?s a ?o .}
LIMIT 10;
#################
then:
isql 1111 dba dba 'test.isql'
gives (with whitespaces, always a different number 42, 35, 38)

http://dbpedia.org/resource/Alfonso_Arauhttp://dbpedia.org/ontology/Actorhttp://dbpedia.org/resource/Alfonso_Cuar%C3%B3nhttp://dbpedia.org/ontology/Actorhttp://dbpedia.org/resource/Amitabh_Bachchanhttp://dbpedia.org/ontology/Actor

instead of

http://dbpedia.org/resource/Alfonso_Arau \thttp://dbpedia.org/ontology/Actorhttp://dbpedia.org/resource/Alfonso_Cuar%C3%B3n \thttp://dbpedia.org/ontology/Actorhttp://dbpedia.org/resource/Amitabh_Bachchan \thttp://dbpedia.org/ontology/Actor


Is this on purpose? Are there different output formats for the ISQL console?

I know I can replace the whitespaces with sed, e.g. sed "s/ \{1,\}/\t/g"but it might cause problems, when retrieving literals with a sparqlvariable.


Thanks,
Sebastian

[Virtuoso-users] using isql with unix console

Reply via email to