Hi,
i have a invisible symbol in a textfile, problably a “non-breaking-sign” → \x{A0}
i want to replace this at import, how can I search for this “\x{A0}”?
Marco
Hi,
i have a invisible symbol in a textfile, problably a “non-breaking-sign” → \x{A0}
i want to replace this at import, how can I search for this “\x{A0}”?
Marco
I think it is Chr(160), Non Breaking Space (Sticky Space).
It may or not be a gremlin (this depends on where it is in the text and the grammar rules for your country)
Google string to use for more details (and values):
unicode non breaking space
I forgot the code to Replace one string with another…
Syntax:
Replace(oldString As String, newString As String) As String
Sample code in the documentation (link above)
thank you!
I always tried to search for that unicode string…