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