DB Max

[Mayur_Ganesh_Mandge]

@msalesforce777 sharing linq for max matching in string with specific characters and return row number.

[msalesforce777]

Dim searchTerm As String = “South coast, United Kingdom”
Dim reg As Regex = New Regex(“[*'”“,_&#^@]”)
searchTerm = reg.Replace(searchTerm, String.Empty)
Dim regex = New Regex(“(+|@|&|,|'|(|)|<|>|#)”)
Dim lstMatches As List(Of String) = dtbInput.AsEnumerable().Where(Function(r) regex.Replace(Convert.ToString(r.Field(Of Object)(“Column1”)).Trim().Replace(“.”, String.Empty), String.Empty).ToString().Split(" “c).ToList().Intersect(searchTerm.Split(” “c).ToList()).ToList().Count() >= (searchTerm.Split(” "c).ToList().Count())).[Select](Function(s) Convert.ToString(s.Field(Of Object)(“Column1”)).Trim()).ToList()