Character ? replacement 1

[jmcg]

I have a character ? appearing in a data stream. I have tried to get it changed in the feed but cannot so need to replace it. However I cannot find the character in the ASCII mappings. When I paste ? into a VBA module it appears as „¢. I have tried to replace this but it is not found.
Any suggestions on how I can replace this character?

 

[PaulBricker]

Asc("?") returns 63

Chr(63) returns ?

Is that what you are looking for?


Paul

 

[jmcg]

Paul
Thanks but no. When I previewed this post it showed the character correctly but in the final post it changed to ?.
Will try it in a code box to see if that helps.

 ?

 

[jmcg]

Still the same!!!
As an image

it is the bit in the middle.
Thanks again

 

[PaulBricker]

Can you check for valid characters and try and trap it that way? You could create a function that tests all the characters in your string against the Ascii list and if it doesn't register then try using a Replace function to change it.
I can assist with the Function if you need it.


Paul

 

[jmcg]

Thank Paul that sounds like the way to do it. Seems strange though that is does not appear in ASCII or in the Windows Character Map either!
Will be ok doing the function, thanks for the offer.

 

[PaulBricker]

I checked some character sets (HTML, Windows and stuff) and couldn't find the character either.
Good luck.

Paul