Re: The Better Looking Output After the SPARQL Query in Java Code

[Dave Reynolds]

On 20/08/13 16:12, Darius Miliauskas wrote:

Dear All,

I already solved the issue using the manipulations with Java code. However,
the question how to solve it in a SPARQL query is still open.

You can do things like:

BIND(REPLACE(str(?person),'.*[/#]([^/#]+)','$1') as ?label)

then display the ?label.

Dave

My solution with Java code is:

        String result:
         while (results.hasNext()) {
             QuerySolution solution = results.next();
             result = solution.get("?room").toString();
             result = result.substring(result.indexOf("#") + 1,
result.length());
             System.out.println(result);
         }
         qe.close();


Best,

Darius


2013/8/20 Darius Miliauskas <dariui.miliaus...@gmail.com>

Subject: The Better Looking Output After the SPARQL Query in Java Code
To: users@jena.apache.org


Dear Sir or Madam,

I am using the SPARQL query in Java (actually, NetBeans). The query works
fine, however, the results are outputted not in the nice form.

The example of my code (Java) is the following:

String queryString2 ="PREFIX base: <
http://www.semanticweb.org/darius/ontologies/2013/6/rooms#>"
                  + "PREFIX rdf: <
http://www.w3.org/1999/02/22-rdf-syntax-ns#>"
                 + "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>"
                 + "PREFIX owl: <http://www.w3.org/2002/07/owl#>"
                 + "PREFIX foaf: <http://xmlns.com/foaf/0.1/>"
                 + "SELECT ?person ?room WHERE { ?person a base:Person.
?room a base:Room."
                 + "FILTER regex(STR(?person), \"Ana\") }"
                 + "ORDER BY DESC (?person)";
Query query = QueryFactory.create(queryString2);
         QueryExecution qe = QueryExecutionFactory.create(query, model);
         com.hp.hpl.jena.query.ResultSet results = qe.execSelect();
         ResultSetFormatter.out(System.out, results, query);
         ResultSetFormatter.asText(results, query);
         qe.close();

I get the results in the following form:

----------------------------------------------------------------------------------------------------
| person   | room
                          |

====================================================================================================
| base:Ana | <
http://www.semanticweb.org/darius/ontologies/2013/6/rooms#Rue_de_Mont_Blanc,_Geneva>
|

----------------------------------------------------------------------------------------------------

Is there any possibility in SPARQL to cut or substring these additional
parts ("Ana instead of "base: Ana" or "Rue_de_Mont_Blanc,_Geneva" instead
of the "<
http://www.semanticweb.org/darius/ontologies/2013/6/rooms#Rue_de_Mont_Blanc,_Geneva>")?
I tried FILTER (SUBSTR(?person, 4)) in the query, but it did not give me
the desired results. Or it is recommended to do in Java? How to do it?


Thanks for any suggestions,

Darius Miliauskas