Hi,
Am 25.06.2010 04:11, schrieb Hugh Williams:
Hi Sebastian,
There are not other output formats for isql, what are you seeking to do with
its output that requires the use of tab to delimit column values ?te usefull
it is not an urgent problem that I have, but it would be quite usefull.
It is currently impossible to do anything with the data that comes out
of the isql console because of the arbitrary whitespace formatting.
e.g. you can not pipe it to a file and then load it into an application
that reads csv or something similar.
Regards,
Sebastian
The options that can be passed to it are:
$ /opt/virtuoso/bin/isql -?
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Usage :
isql<HOST>[:<PORT>]<UID> <PWD> file1 file2 ...
isql -H<server_IP> [-S<server_port>] [-U<UID>] [-P<PWD>]
[-E] [-X<pkcs12_file>] [-K] [-C<num>] [-b<num>]
[-u<name>=<val>]* [-i<param1> <param2>]
isql -?
Connection options:
-? - This help message
-U username - Specifies the login user ID
-P password - Specifies the login password
-H server_addr - Specifies the Server address (IP)
-S server port - Specifies the TCP port to connect to
-E - Specifies that encryption will be used
-C - Specifies that password will be sent in cleartext
-X pkcs12_file - Specifies that encryption& X509 certificates will
be used
-T server_cert - Specifies that CA certificate file to be used
-b size - Specifies that large command buffer to be used
(in KBytes)
-K - Shuts down the virtuoso on connecting to it
Parameter passing options:
-u name1=val1... - Everything after -u is stored to associative array U,
until -i is encountered. If no equal sign then value
is NULL
-i - Ignore everything after the -i option, after which
comes arbitrary input parameter(s) for isql procedure,
which can be referenced with $ARGV[$I] by the
ISQL-commands.
<OPT>=<value> - Sets the ISQL options
Note that if none of the above matches then the non-options go as
<HOST>[:<PORT>]<UID> <PWD> file1 file2 ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 24 Jun 2010, at 08:19, Sebastian Hellmann wrote:
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 between
result 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_Arau
http://dbpedia.org/ontology/Actor
http://dbpedia.org/resource/Alfonso_Cuar%C3%B3n
http://dbpedia.org/ontology/Actor
http://dbpedia.org/resource/Amitabh_Bachchan
http://dbpedia.org/ontology/Actor
instead of
http://dbpedia.org/resource/Alfonso_Arau \t
http://dbpedia.org/ontology/Actor
http://dbpedia.org/resource/Alfonso_Cuar%C3%B3n \t
http://dbpedia.org/ontology/Actor
http://dbpedia.org/resource/Amitabh_Bachchan \t
http://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 sparql
variable.
Thanks,
Sebastian
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
