Jim Moseley wrote:
Quote:
Tony,
And my question is whether the data in these memo fields, or some of it,
is
from copy/paste from Internet pages or other applications.
A LOT of garbage, that the user can't see, is captured along with text when
doing copy/paste of text from Internet pages.
Good guess.
Jim Moseley |
Not exactly a guess. I've seen it many times.
I believe that if you write the captured text to a textstream, then read back
out using a text stream, you get rid of the 'bad' characters.
Might be able to do this just copying from a memo var to a string var during
the capture process.
One of the worst things that happens during this exchange is that web pages
can contain NULL characters. Which trash fields of data. Even chr(13) or
chr(10) can make some data appear to say 'new record' when it isn't intended.
--
---------------
Tony McGuire
http://www.lostlore.com