Text in Web query truncated due to < and % symbols
 

I am maintaining a medical questionnaire site that uses a web query in excel
to show results.

The asp page polled by the excel is correct in a browser. The site shows up
correctly when added as a web query. But on import it truncates the question.

The question is "17. Achievement of <50% residual in-segment percent
diameter stenosis i.e. at least half of the lumen is patent on post-procedure
angiogram indicates:" which on import truncates at the "of".

I tried formatting the cell as text, but it looks like this is trapped
earlier.

Is there a way to escape this - I prefer not to change the client's text to
"less than" but that may be the way it is delivered - if there was going to
be a problem, I'd have assumed it'd be at the ASP stage, not here...

Text in Web query truncated due to < and % symbols
 

Adding a space between < and 50% worked, which will pass muster with the
client, but if there is a solution, I'd still like to hear it.

"keith" wrote:

I am maintaining a medical questionnaire site that uses a web query in excel
to show results.

The asp page polled by the excel is correct in a browser. The site shows up
correctly when added as a web query. But on import it truncates the question.

The question is "17. Achievement of <50% residual in-segment percent
diameter stenosis i.e. at least half of the lumen is patent on post-procedure
angiogram indicates:" which on import truncates at the "of".

I tried formatting the cell as text, but it looks like this is trapped
earlier.

Is there a way to escape this - I prefer not to change the client's text to
"less than" but that may be the way it is delivered - if there was going to
be a problem, I'd have assumed it'd be at the ASP stage, not here...