Check for the existence of a value from Datatable (return value: Boolean type)

Hi

But before going for alternative way Make sure your Substring expression is mentioned as expected

And Try in the other way around

Like this

Dt_TDI_PL.AsEnumerable.any(Function(r) item_formula.ToString.Substring(1).Contains(r(“科目”).ToString.Trim))

Again Make sure your Substring expression is mentioned as expected

Cheers @111962

2 Likes