Counting in a string

[JohnBoy2005]

Is there a function that would work out how many of a character is in a string

For example, how many ";" are in

1;2;3;4;5;6

Cheers

John

 

[johnwm]

Yes - the Split() function.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[JohnBoy2005]

Thanks for that. I've used it with Ubound to get the amount.

Cheers for the clues

John

 

[johnwm]

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints