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 ?
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
