jwcolby
jwcolby at colbyconsulting.com
Wed Jul 25 08:20:05 CDT 2007
Wow. That does work. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Foote, Chris Sent: Wednesday, July 25, 2007 6:38 AM To: 'dba-vb at databaseadvisors.com' Subject: Re: [dba-VB] Count of specific character Morning John! I do not know of any specific special function to do this, but there's a trick I use in Excel using the SUBSTITUTE function. I use LEN to get the number of characters in the original string. Use SUBSTITUTE to replace the character I need to count with "" (nothing). LEN the results and subtract this from the original LEN. Hope this helps! Regards Chris Foote > -----Original Message----- > From: dba-vb-bounces at databaseadvisors.com > [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of jwcolby > Sent: Tuesday, July 24, 2007 8:33 PM > To: dba-vb at databaseadvisors.com > Subject: [dba-VB] Count of specific character > > > Is there any single function that will return a count of a specific > character in a string? > > I have a situation where (apparently) the header of a CSV file has the > same field name twice. I am trying to determine what is going on, so > I want to count the field separator characters in the header and the > first line of real data to see if there are more fields in the header > than in the data or if something else is going on. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com