OK, I think now I get a better idea of what you want to do. It won't work in a general case because RDF resources can have duplicate properties but CSV shouldn't have duplicate columns.
On Thu, Apr 22, 2021 at 11:41 AM Mikael Pesonen <[email protected]> wrote: > > > I think that is for serializing the triplets as they are, in cleaner > format, but it doesn't say anything about rearranging the data. > > On 22/04/2021 12.34, Martynas Jusevičius wrote: > > This is probably what you want: > > https://www.w3.org/TR/sparql11-results-csv-tsv/ > > > > Try curl -H "Accept: text/csv" with SELECT results. > > > > On Thu, Apr 22, 2021 at 11:30 AM Mikael Pesonen > > <[email protected]> wrote: > >> > >> Hi, > >> > >> not exactly Jena related, but does anyone know if there is a tool or > >> sparql query that would read (almost) any kind of RDF data and make a > >> csv sheet where each column has predicates as headers and values as > >> cells. It would also be nice to get linked resources into the table the > >> same way. Even a hint how to make each predicate a new column in sparql > >> would be helpful. > >> > >> So for example > >> > >> :s :p1 "label1" . > >> :s :p2 "label2" . > >> :s :p3 :s2 . :s2 p1 "label3" > >> > >> -> > >> :p1 :p2 :p3/:p1 > >> :s label2 label2 label3 > >> > >> Br, > >> Mikael > >> > > -- > Lingsoft - 30 years of Leading Language Management > > www.lingsoft.fi > > Speech Applications - Language Management - Translation - Reader's and > Writer's Tools - Text Tools - E-books and M-books > > Mikael Pesonen > System Engineer > > e-mail: [email protected] > Tel. +358 2 279 3300 > > Time zone: GMT+2 > > Helsinki Office > Eteläranta 10 > FI-00130 Helsinki > FINLAND > > Turku Office > Kauppiaskatu 5 A > FI-20100 Turku > FINLAND >
