invalid token problem ?

[tag]

Hi,

I have a xml field:

<Cell Col="2" Row="10">="Actu al Asset mix
"&text($C$46,"d d-mmm-yyyy")</Cell>
^
|
this is column 56

and am getting the following error:

xml.sax._except ions.SAXParseEx ception: <stdin>:21:56 : not well-formed
(invalid token)

I have used the :
self.data += saxutils.escape (characters, self.transhash)

and transhash has :

transhash = { '"' : '&quot;', '&' : '&amp;' }

Can anyone please explain why I am getting the error ? What am I
missing ??

THANKS :)

[Thomas Krüger]

tag wrote:

Can anyone please explain why I am getting the error ? What am I
missing ??
Well the answer is already given:
xml.sax._except ions.SAXParseEx ception: <stdin>:21:56 : not well-formed

Your XML is not well-formed. All quotation marks in CDATA fields (outside of
a tag) must be quoted to &quot;.

You XML should be:

<Cell Col="2" Row="10">=&quot ;Actual Asset mix
&quot;&text($C$ 46,&quot;dd-mmm-yyyy&quot;)</Cell>

Thomas

[tag]

Thomas Krüger <th************ @gmx.net> wrote in message news:<ch******* ******@news.t-online.com>...

Your XML is not well-formed. All quotation marks in CDATA fields (outside of
a tag) must be quoted to &quot;.
I got that part :)
You XML should be:
<Cell Col="2" Row="10">=&quot ;Actual Asset mix
&quot;&text($C$ 46,&quot;dd-mmm-yyyy&quot;)</Cell>

but they are - it is complaining about the :
&text part ... the '"' 's are converted into &quot; ...

any other suggestions ?

[Peter Otten]

tag wrote:

Thomas Krüger <th************ @gmx.net> wrote in message
news:<ch******* ******@news.t-online.com>...

Your XML is not well-formed. All quotation marks in CDATA fields (outside
of a tag) must be quoted to &quot;.

I got that part :)

You XML should be:
<Cell Col="2" Row="10">=&quot ;Actual Asset mix
&quot;&text($C$ 46,&quot;dd-mmm-yyyy&quot;)</Cell>

but they are - it is complaining about the :
&text part ... the '"' 's are converted into &quot; ...

any other suggestions ?

I think you misunderstood - the original xml is invalid. In your short
snippet you could remedy that by snippet = snippet.replace ("&", "&amp;")
_before_ feeding it to the parser. Unfortunately this doesn't work in the
general case because not all occurences of '&' may be literal ampersand
chars and not all occurences of '<' and '>' may be markup. Therefore what
you need to do is to fix the program that _generates_ the invalid xml not
the one that tries to parse it and fails. If the generating program is in
python, you can use xml.saxutils.es cape() to process the literal text
snippets, but only those.

Peter