Hi Jan, would you be able to clarify what feature you are referring to? I don't think the Form panel has Excel export. Do you mean export from the results of the SPARQL Query panel? That does not have Excel export, although it has tab-separated values export.
To make this precise I ran this query: prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT * WHERE { BIND ("Äldi"^^rdf:HTML AS ?shop) . BIND (<http://uispin.org/ui#convertHTMLToText>(?shop) AS ?text) . } and exported it to TSV, producing ?shop ?text "Äldi"^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#HTML> "Äldi" which at least indicates that convertHTMLToText has different output. But it produces verbatim rendering of the first column, which looks reasonable. Thanks Holger > On 24 Jan 2024, at 3:15 pm, Jan Campschroer <campschr...@planet.nl> wrote: > > Hello, i've got a related question. In the Excel-export from te Form-panel > there is stille some html-code (like <strong>xx</strong> and ë instead > of xx and ë) is visible. Is there a WYSIWG Export to Excel? > The function ui:convertHTMLToText has the same output. > > Regards, Jan > > Op woensdag 3 maart 2021 om 18:42:11 UTC+1 schreef Kevin Guest: >> Hi Irene, >> I appreciate your taking the time to reply. >> I'll see if I can apply your suggestions. >> --Kevin >> >> On Tue, Mar 2, 2021 at 6:33 PM Irene Polikoff <ir...@topquadrant.com <>> >> wrote: >>> 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.wc...@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-user...@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-user...@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 >>> >>> <https://groups.google.com/d/msgid/topbraid-users/E61D2B96-3435-43D0-BA92-99A422DB3CAC%40topquadrant.com?utm_medium=email&utm_source=footer>. > > > -- > The topics of this mailing list include TopBraid EDG and related technologies > such as SHACL. > To post to this group, send email to topbraid-users@googlegroups.com > --- > 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/50579897-1cf5-4deb-9298-19184088f7acn%40googlegroups.com > > <https://groups.google.com/d/msgid/topbraid-users/50579897-1cf5-4deb-9298-19184088f7acn%40googlegroups.com?utm_medium=email&utm_source=footer>. -- The topics of this mailing list include TopBraid EDG and related technologies such as SHACL. To post to this group, send email to topbraid-users@googlegroups.com --- 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/82A4718A-7EAF-4D0C-9B2F-1CA20D3B248E%40topquadrant.com.
