How can i remove the special characters from Destination ,i want to remove all the text after underscore, How i write the linq query for this, Please help?Thank you in advance


I am trying this , but this is not working, want to remove all characters from excel file destination column and then compare.

Hi @Anjali_Rani

Have you try Split("")(0) instead of Replace("*","/") ? Split delimiter is underscore character.