Kevin,
You can try the following SPARQL query
SELECT ?term ?def
WHERE {?term skos:definition ?d
BIND (ui:convertHTMLToText(?d) AS ?def)
}
Make sure to define the prefix for ui:
Expand the area where prefixes are defined and start typing PREFIX then space -
you will get a list of known prefixes/namespaces to choose from.
Then, you could export results in TSV or XML.
This conversion function is not perfect. It will remove bold text, bullets,
images, paragraph, but the hyperlink values will remain there. There could also
be some issues with the new lines in the TSV export.
If we have time, we will see if we can improve it for 7.0.
Regards,
Irene Polikoff
> On Mar 2, 2021, at 2:33 PM, Kevin Guest <vi.wcc....@gmail.com> wrote:
>
> Hello,
>
> In one of our glossaries we use rich text format to populate definition
> fields. Sometimes I need to export a set of definitions, but when I export
> to Excel or CSV the markup is included. Is there a way to export to Excel
> with just the text? Some definitions are written in paragraphs, have lists
> of values, some hyperlinks, bold text, etc., but I don't need any of that --
> just the text definitions.
>
> I haven't used SPARQL to do querying or other functions but I am open to
> learning if that's the solution.
>
> Thanks,
> Kevin
>
> --
> You received this message because you are subscribed to the Google Groups
> "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to topbraid-users+unsubscr...@googlegroups.com
> <mailto:topbraid-users+unsubscr...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/topbraid-users/CAPQ9gY9vCq_BU1nZ7HJLzwzW%3Dh7dpHtYDADgJBPw32jXWO7TmQ%40mail.gmail.com
>
> <https://groups.google.com/d/msgid/topbraid-users/CAPQ9gY9vCq_BU1nZ7HJLzwzW%3Dh7dpHtYDADgJBPw32jXWO7TmQ%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/topbraid-users/E61D2B96-3435-43D0-BA92-99A422DB3CAC%40topquadrant.com.
