Matching id with ignoring 1 character

Help Something Else
2

Hi,

We can achieve this using TrimEnd method, as the following, for example.

newDt = dt1.AsEnumerable.Where(Function(r) dt2.AsEnumerable.Any(Function(r2) r2("id").ToString=r("id").ToString.TrimEnd("'"c))).CopyToDataTable

Regards,