G
Guest
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...
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...