I have this code that pulls in an excel file and removes some columns. It works great in a stand alone application, but the moment I add the code to an existing application and refresh via server, it fails.
From what I can tell, when the code is run as part of the larger application an extra character is added that isn't actually present in the script which is what causes it to fail.
Any idea why this character (note the A with the circle) is being added?
Thank you. I thought that too but removing the extra space didn't affect it.
I did notice that the field "Not" is underlined in the excel file, but again I dont understand why sometimes the server adds that character and other times it doesnt. It is run using the same server, just in two different qvw.
Chase, that seems to equate to an ASCII Â, only thing of which I can think to do is put this into a text editor that will show formatting etc., like Word and turn on the symbols etc. to see if something shows up that way. Maybe this is happening when you copy/paste, so the other thing would be to try typing it manually once to see if it still occurs that way...
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.