Hi Holger, thank you for your actions. It's also good to know that ther isn't (yet) a solution to the problem.
Regards, Jan Op donderdag 25 januari 2024 om 12:39:20 UTC+1 schreef Jan Campschroer: > Hello Holger,[image: 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: > >> [image: Edg export excel.PNG] >> >> 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 <[email protected]> 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 <[email protected]> >>>> 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 <[email protected]> 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 [email protected]. >>>>> 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 [email protected]. >>>>> >>>> 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 [email protected] >>> --- >>> >>> 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 [email protected]. >>> >>> 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 [email protected] --- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/e8adb819-2ad3-4de2-9074-ce4d4647da74n%40googlegroups.com.
