Hi Team, How to compare text file with the excel file. Excel file Values:BG000011,BG000022,BG000033… If excel file values matches with any line of text file,copy the total line of data in to another text file. Appreciate your immediate help. Regards, Rajesh

ReadExcelAndCheck.xaml (10.3 KB) Check the updated workflow and let me know in case of any query

How to compare text file with excel file

sarathi125 (Parthasarathi) October 10, 2019, 11:12am 13

Check this workflow, I assume always the footer will be your last line in the summary text file.

Topic		Replies	Views
How to compare equality Help excel	24	2440	December 11, 2018
Compare Excel Files Tutorials	19	5287	October 8, 2020
How to compare data from a excel sheet with another excel sheet and highlight differences in first excel sheet row Studio excel , studio , question , activities_panel	4	807	December 25, 2021
How can I check line-by-line all the data inside of the file is the same to the other file? Studio studio , question , activities_panel	11	420	December 21, 2022
How to copy the data from text file to new text file based on excel values Help studio	2	1031	September 26, 2019