hi. i want to match id from dt1 and dt2 i want to match them while ignoring 1 character in the id. the dt1 ids have (‘) in the end. the reason why i put (’) in the id in dt1 cause the excel auto change the ids after my first output.

Hi, All right. Can you try the following expression? findrow = MSMEDT.AsEnumerable.Where(Function(x) x(3).ToString.Equals(currentrow(7).ToString.TrimEnd("'"c)).FirstOrDefault() Regards,

Matching id with ignoring 1 character

Help Something Else

Yoichi (Yoichi) December 9, 2022, 4:34am 11

Hi,

For now, can you export worksheet of dt2 to csv file, then compare both record using text editor?
There might be something diffrence such as whitespace etc.

Regards,

Topic		Replies	Views
Match string from DataTable without IF Activities datatable , excel , question	10	925	February 1, 2021
Filtering Data Community question , community	13	544	December 13, 2022
Best way to remove matching column values in two different data tables? Studio studio , question , activities_panel	7	613	March 20, 2023
Excel Duplication matching Studio studio , question , activities_panel	12	597	June 1, 2023
Excel Automation 3 Something Else feedback	8	909	October 4, 2022

Matching id with ignoring 1 character

Related topics