I'll try looking into that more. The CSV file is the following: ________________________________________________________________ Invoice Number,ARCRX_0000258 Invoice Date,"04/08/2010 09:18AM" Customer Name,"Jim Hugh" Customer Firm,"S.R.W. Architecture, Inc." Product ID (View Name),Detail ID,Detail T...

I have been working on and had help on creating a macro that compares two list and returns which numbers are different between the two lists. With some help I got it working in an ideal setting in which both lists are simple TXT files with one number per row however in reality I will be comparing a ...

Hey that works perfect. I appreciate your taking your time to help! It works perfect and is much much cleaner!

Thanks again!

ReadFile>C:\Users\Preferred User\Desktop\List1.txt,List1 Separate>List1,CR,Array1 ReadFile>C:\Users\Preferred User\Desktop\List2.txt,List2 Separate>List2,CR,Array2 Messagemodal>Array1_count if>Array1_count=0,End Let>k=0 Repeat>k Label>Continue Let>k=k+1 MessageModal>Array1_%k% Gosub>Search If>Array1...

This sounds promising!

I can play around with this. I am still new to it all so Ill have to do some fiddling around to figure out creating the arrays but it sounds like that will work! Thanks!

Sorry I will continue to try the DOS command changing the params., It looks like it is on the right track.

It seems as if the DOS command goes through the lists 1 line at a time and compares line one to line 1 etc. It was also including other lines before and after the mismatched lines which was getting quite confusing. It looks like it is in the right direction but not exactly what I am looking for yet....

The numbers may not necessarily be in the same order in each list. I have gotten it to compare the lines one line at a time but it wouldnt work if the two files were out of order or if one list was missing a number etc. I can try the DOS command and see how that works out thanks!

I am trying to compare two lists that are found in two text files. I have been using Readln to read through the files but am having trouble coming up with a way to compare it against another list and tell me which numbers in the lists do not match up to each other. The lists look something like this...

Trying to figure out how to delete my past posts!