How turn a cell into proper XML exportation?

[jbesclapez]

Hi there,

I am using excel to create an XML file.
I am getting a problem I can not solve easily: How to convert a cell that contains text with single and double quotes to my XML. I looked at <![CDATA[ but cannot make it work for me. As an example is usually better than words, here it is:

Here is the data i want to send for expression

'ThisIsMyExpression
api.Message(si,"Check this message")

Here is what the system is expecting :
<Expression="'ThisisMyExpression&#xD;&#xA;api.Message(&quot;test&quot"/>

In excel it looks like this

And my formula in excel is
="<Expression="&""""&" "&G4&""""&" />"

As i mentioned previous I tried to use ![CDATA[ but without successs too.

Thanks for your help

 

[jbesclapez]

Hi guys,
I found a workaround using directly an excel formula that will spot the unauthorized characters and swap them with what I need.
Here is the formula i use:
TRIM(SUBSTITUTE(SUBSTITUTE(G4,CHAR(34),"&quot;"),CHAR(10),"&#xD;&#xA;"))
Did not know we could find an ENTRY in excel...
Cheeers