Search code examples
selectsparqldbpedia

select one output query SPARQL


I've written this query in sparql:

SELECT ?spouse
WHERE {
dbr:Zach_Galifianakis dbp:spouse ?spouse.
}

and I have this output:

2012
""@en
"Quinn Lundberg"@en

(https://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=SELECT+%3Fspouse%0D%0AWHERE+%7B%0D%0Adbr%3AZach_Galifianakis+dbp%3Aspouse+%3Fspouse.%0D%0A%7D%0D%0A&format=text%2Fhtml&timeout=30000&signal_void=on&signal_unconnected=on)

I don't understand how to select only the name "Quinn Lundberg"@en. I've tried using FILTER clause but it doesn't work.


Solution

  • Not a generic solution, but this will fetch only the name for your case:

    SELECT *
    WHERE {
    dbr:Zach_Galifianakis dbp:spouse ?spouse.
    FILTER (strlen(str(?spouse)) > 0 && lang(?spouse) = 'en')
    }
    

    Output