Concat values from a datatable column excluding some

Learn Academy Feedback
1

Is there any way to concat values from a datatable column excluding some values and blanks, without using for each loop?

E.g.

Problem | Remarks
Test | Nothing much
Test1v |
Test2 | Need to Add more
Test3 | Nothing Much
Test4 | Too much Info

Result:
Need to Add more; Too much Info

2

IF You know the row index or specified rows which you need to concat the you should try this once
datatablevariable.rows(2).item(1).tostring+“;”+datatablevariable.rows(4).item(1).tostring
here rows(2) means 3rd row and item(1) means column of Remarks
image
thanks if any let me know…

3

@TyraS

You can try like this

String.Join(";",Dt.AsEnumerable.Where(function(x) Not {"","Nothing much"}.Contains(x("Remarks").ToString.Trim)))

Cheers