[dba-VB] Count of specific character

jwcolby jwcolby at colbyconsulting.com
Tue Jul 24 14:32:57 CDT 2007


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 




More information about the dba-VB mailing list