[dba-VB] Count a character in a string

I like #2 and in fact I seem to have read that one before somewhere.  I 
am running through a file with millions of lines so it has to be as fast 
as possible.

Thanks,

Drew Wutka wrote:
> Hmmm, two ways I can think of.
> 
> One:
> 
> Dim strRecordLine() as array
> strRecordline=split(yourstringhere,"|")
> NumberOfSeperatorCharacters=UBound(strRecordline)+1
> 
> Two:
> Dim strTemp as String
> strTemp=Replace(yourstring,"|","")
> #ofCharacters=Len(yourstring)-len(strTemp)
> 
> Drew
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Saturday, April 12, 2008 3:24 PM
> To: VBA
> Subject: [dba-VB] Count a character in a string
> 
> I do a lot of CSV stuff.  One of my file suppliers gives me files that 
> throw an error when I try to import them and so I am writing tools to 
> try and troubleshoot these files.  I need to be able to count the times 
> that the field separator character is contained in a line.  The error I 
> am getting says the line is too long but I have determined that is not 
> the case.  I suspect that perhaps the field separator character is in 
> the line too often.
> 
> So, if I have a line that looks like:
> 
> asdf|qwert|zxcv|mnbv
> 
> Other than just iterating through the string character by character, is 
> there a way to get a count of the | character in the string?

-- 
John W. Colby
www.ColbyConsulting.com