I have a list of full names, some of them may be repeated, but only the copy contains the last name and first name, and there is no middle name. I need to delete such copies, and leave the list with only the full name. For example,
what is at the moment:
what I would like to implement:
I will be grateful for any help
Can you try the following expression?
dt = dt.AsEnumerable.Where(Function(r) not dt.AsEnumerable.Any(Function(r2) System.Text.RegularExpressions.Regex.IsMatch(r2("FULL NAME").ToString,"^"+r("FULL NAME").ToString+".+"))).CopyToDataTable
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.