Author Topic: Sheet Set translation (DST>XML>DST)  (Read 12468 times)

0 Members and 1 Guest are viewing this topic.

framednlv

  • Newt
  • Posts: 64
Re: Sheet Set translation (DST>XML>DST)
« Reply #15 on: January 28, 2020, 06:17:26 PM »
Is this something that can be fixed or is this something I need to work around?

A literal ampersand within XML values is not valid and therefore needs to be escaped using &

In general, this also applies to the following five characters:

"   "
'   '
<   &lt;
>   &gt;
&   &amp;

Lee,
Thanks I added to my code:
 DSTData = Replace(DSTData, " &amp; ", " & ")
and reversed it when saving out.
I'll look at the others you posted and see if I need to add some more code.

jtm2020hyo

  • Newt
  • Posts: 198
Re: Sheet Set translation (DST>XML>DST)
« Reply #16 on: March 14, 2020, 02:31:41 AM »
I just returdned to say thanks for your lisp. finally works for me... but I used it with Excel or LibreOffice.

jtm2020hyo

  • Newt
  • Posts: 198
Re: Sheet Set translation (DST>XML>DST)
« Reply #17 on: March 14, 2020, 02:47:27 AM »
... I forget to tell you, I found one .NET code and I update it, that was a way to auto - renumbering sheet set. maybe you can translate it to LSP DCL OpenDCL.

https://www.theswamp.org/index.php?topic=55116.new#new

https://forums.autodesk.com/t5/net/how-to-recycle-an-2014-vb-net/td-p/8743719