Count how many "commas" are in a line.

Question

I need a code to count how many commas there are in a richtextbox line. If there are 4 or more commas then do something, else delete line.

Answer 1

It's C#, but you could do something like this:

int count = 0;

foreach(char c in string)
{
    if(c == ',') count++;
}

return count;

Answer 2

what about this:

string test = "abc,123,dfg";
int count = test.Split(',').length - 1;

sorry i'm a c# guy. Here is vb.net (i think):

Dim test As String = "abc,123,dfg"
Dim count As Integer = test.Split(',').length - 1

Answer 3

    Dim str As String = "Count, the, commas,,, !"

    Dim count As Integer = 0

    For Each c As Char In str
        If c = "," Then
            count += 1
        End If
    Next

Vote up Dan @ Demand's answer, this is just the VB.Net version.

Answer 4

var str = "Count, the, commas,,, !";
var answer = str.Length - str.Replace(",", "").Length;

Answer 5

Here's the obligatory LINQ answer:

Dim cnt As Integer = yourString.Count(Function(ch) ch = ","c)

Answer 6

if( new RegEx(",").Match(s).Matches.Count > 4 ){
    //insert logic here
}

I'm doing this off the top of my head so don't kill me if it's not perfect code, but you get the gist of what i'm doing. You can leverage a regular expression to tell you exactly how many commas there are and to perform the required logic if the condition is met.

Answer 7

This will actually give the required result (i.e. a string with the invalid lines removed):

Dim lines As String() = richTextBox.Text.Split(vbCrLf)
Dim validLines = lines.Where(Function(l) l.Count(Function(c) c = ","c) = 4)
Dim results As String = String.Join(vbCrLf, validLines)