How to get the count from the column?

[Vrishchik (Naveenkumar Shivaraju)]

Hi All,
I need to get the count of a column(“Code”), based on the below condition:
if the column contains or start with “992” I dont want to consider in the total count, if the the column name doesn’t contains the “992” then I need to consider the total count.
for example:
if the column “Code” contains: the numbers
99213
88913
90351
99006
from the above values of the column I need to skip the 99213, so the count is 3(88913,90351,99006)

how can I achieve this, please help me.

@ushu
@ppr
@Yoichi
@vishal.kp
@Gokul001
@lakshman
@Chirag_Shetty_Divakar
@jack.chan

[Vrishchik (Naveenkumar Shivaraju)]

[supermanPunch (Arpan)]

@Vrishchik

if the column “Code” contains: the numbers
99213
88913
90351
99006
from the above values of the column I need to skip the 99213, so the count is 3(88913,90351,99006)

Hi @Vrishchik ,

Maybe you could check with the below Expression :

DT.AsEnumerable.Where(Function(x)Not(x("Code").ToString.StartsWith("992"))).Count

[Vrishchik (Naveenkumar Shivaraju)]

This is datatable column

[vishal.kp (vishal)]

Hi @Vrishchik ,

use the below expression:

dt.AsEnumerable.Count(function(x) not x(“Code”).ToString.Contains(“992”))

[Vrishchik (Naveenkumar Shivaraju)]

It should not take the count of null or empty.
because it is taking null value also.
instead of 2 it is showing 3

[vishal.kp (vishal)]

@Vrishchik ,
Updated:

dt.AsEnumerable.Count(function(x) not x(“Code”).ToString.Contains(“992”) and not string.IsNullOrEmpty(x(“Code”).ToString))

[supermanPunch (Arpan)]

@Vrishchik

It should not take the count of null or empty.

@Vrishchik ,

Updated :

DT.AsEnumerable.Where(Function(x)x("Code").ToString.IsNumeric andAlso Not(x("Code").ToString.StartsWith("992"))).Count