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:20am 9

Hi,

Can you share actual data?

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