Not getting expected output from Except function

[Yoichi]

Hi,

If your data doesn’t contains tab (for example), can you try the following?

dt1 = dt1.AsEnumerable.OrderBy(Function(r) String.Join(chr(9),r.ItemArray)).CopyToDataTable
dt2 = dt2.AsEnumerable.OrderBy(Function(r) String.Join(chr(9),r.ItemArray)).CopyToDataTable

Dim idx1 As Int32 = dt1.Rows.Count-1
Dim idx2 As int32 = dt2.Rows.Count-1
While (idx1>=0 AndAlso idx2>=0)
    If (String.Join(chr(9),dt1.Rows(idx1).ItemArray)=String.Join(chr(9),dt2.Rows(idx2).ItemArray)  )
	dt1.Rows.RemoveAt(idx1)
	    idx1=idx1-1
    ElseIf (String.Join(chr(9),dt1.Rows(idx1).ItemArray)>String.Join(chr(9),dt2.Rows(idx2).ItemArray))
        idx1=idx1-1
	    Else
	    idx2=idx2-1
    End If	
End While

Main.xaml (7.6 KB)

Regards,