Ok, including the formatting such as the bold font is yet another requirement. I have added this to our ticket but I am not familiar with the code to see if that's realistic/easy with our Excel formatter.
Holger > On 25 Jan 2024, at 12:39 pm, Jan Campschroer <campschr...@planet.nl> wrote: > > Hello Holger,<Edg export excel 2.PNG> > your right, the diacrits are handeld well. > This the source, the result using HTMLLtoText en the desired output > > > Op donderdag 25 januari 2024 om 11:19:52 UTC+1 schreef Jan Campschroer: >> >> >> Op donderdag 25 januari 2024 om 10:16:51 UTC+1 schreef Holger Knublauch: >>> 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 <camps...@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 topbrai...@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-user...@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 > <mailto:topbraid-users+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/9201a450-f473-429d-9519-03d39bd7e6f2n%40googlegroups.com > > <https://groups.google.com/d/msgid/topbraid-users/9201a450-f473-429d-9519-03d39bd7e6f2n%40googlegroups.com?utm_medium=email&utm_source=footer>. > <Edg export excel 2.PNG> -- 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/EE18BCE3-6957-479C-9D45-B3F55AD55D22%40topquadrant.com.
