Weird character added to script

[cbushey1]

Hi there,

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?

Here is the actual code being used:

Thanks,

[neelamsaroha157]

Not sure what the issue is but just a guess, you have 2 spaces between 'not' & 'province'. You can try fixing & running it again to see if it makes any difference. 

[cbushey1]

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.

[Brett_Bleess]

Chase, that seems to equate to an ASCII &Acirc, 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...

Regards,
Brett

[cbushey1 · Accepted solution]

Thanks Brett. 

It is actually Qlik that is interpreting that character. It doesn't exist in the code. 

Either way, I found a workaround. Instead of using the embedded labels (since I was changing them anyways) I just used Explicit labels and just renamed as I was planning.