jbesclapez
Active Member
- Joined
- Feb 6, 2010
- Messages
- 275
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
Here is what the system is expecting :
<Expression="'ThisisMyExpression
api.Message("test""/>
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
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
api.Message("test""/>
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