Unrecognized character \xA0??

[Jiggerman]

I got this error "Unrecognized character \xA0" when I was tryed to use Perl with Excel (using the Win32 OLE module) I've no idea, what to do about this, nor what it really means to me. the line that it references is:

"my $Book = $Excel -> Workbooks -> Open("$excelFile""

Hmm Curious!

Thanks very much for any help.

 

[Jiggerman]

Hang-on, I've fixed it. IT's amazing how just re-writting the code letter for letter works at solving problems!

Thanks

 

[icrf]

I run Opera as a web browser and paste code into Ultraedit text editor. I don't know which is to blame, but when I copy from opera into UE, multiple spaces come across as that hex character (the way opera renders   ?). UE is also a hex editor, so I just swap it over to hex mode, do a find/replace for A0 to 20 and everything's happy again. You could do the same with a similar regex in a script, too (s/\xA0/\x20/gi). Might need to read the source as binary, but I don't know.

My guess is Opera is to blame, and UE was a smart enough editor to copy it over. I don't know, but I've learned to live with it. Hope it helps.

----------------------------------------------------------------------------------
...but I'm just a C man trying to see the light

 

[Jiggerman]

I was just surprised at how undescriptive the error messae was, Perl is normally pretty good at being helpful, but it was a little random in this case.

cheers