[AccessD] Strange bug

It depends on the font used when displayed as to whether it appears as a 
space.
There is an ascii no-break space Chr(160) or A0 Hex.
And another I think around chr 253, too long since I looked at ansi.sys 
files.

Best to look at record in a hex editor or dump string to a file.


DWUTKA at marlow.com wrote:

>Are you sure they are spaces, and not a strange ASCII character that looks
>like a space?
>
>Drew
>
>-----Original Message-----
>From: JWColby [mailto:jwcolby at colbyconsulting.com] 
>Sent: Monday, September 11, 2006 4:08 PM
>To: 'Access Developers discussion and problem solving'
>Subject: [AccessD] Strange bug
>
>I have "malformed string" in a comma delimited file.  The record in question
>has valid data, but out in the middle of the string has > 3000 spaces and
>InStr() cannot find any spaces out in the area of the string where these
>3000 spaces reside.
> 
>I'm baffled.
> 
>I need to find this string (in a 3 million line file) and not copy just that
>line, but I can't sense the line.
> 
>Weird.
> 
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
> 
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada