Sum of array if x not empty

[arina]

I have arr_Visits and I want to sum it. But it throw exception as it contains “”. How do I modify the expression to sum not empty string only?.

[fernando_zuluaga]

Hey

give a try with

youArray.Where(Function(x) Not String.IsNullOrEmpty(x)).Sum(Function(s) CDbl(s)).ToString()

Regards

[Yoichi]

@arina

How do I modify the expression to sum not empty string only?.

It might be better to get rid of all the non-numeric items.

arr_Visits.Where(Function(s) Double.TryParse(s, New Double)).Sum(Function(s) CDbl(s))

Regards,