[AccessD] Strange bug

JWColby jwcolby at colbyconsulting.com
Mon Sep 11 16:45:30 CDT 2006


Good call.  They are in fact a hex 00.  

The odd part is that I cut one of them into the paste buffer, and then
inserted it between two quotes, and compared that to a space between two
quotes (using the = operator) and got a positive compare.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Monday, September 11, 2006 5:26 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Strange bug

John,

  You sure their spaces?  I'd look at them with a hex editor.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, September 11, 2006 5: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
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list