[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