! Finding A Char From A Variable !

W

Wembly

Thanks everyone for all your help.

I was also wondering how I could possibly do a count of
the number of the search/delimiter char in the string?

Thanks,
Wembly
 
H

HSalim

Wembly,
You should read the code we post and try to understand it -
in my example
Dim Myarray
Myarray = Split(InputStr, Delimiter)

'Add this line to get a count of the delimiters found
NumDelimiters = ubound(MyArray) +1 ' since arrays are zero baed, add 1

......

HS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top