 |
 |
Howdy Renate, I had sent it directly. cat file1 file2 |sort |uniq -d > duplicate_barcodes For Windows users for whom an emulation layer such as VirtualBox or Cygwin is overkill and who encounter issues implementing Gnuwin, there are two options: 1) Windows 10: Enable linux subsystem (it's a Windows feature that's off by default -- all you have to do is turn it on) 2) All versions: Download native win32 ports of the utilities. Installation consists of dumping the executables in a directory. Be sure to add this directory to the front of your path so these programs are triggered before dos/windows utilities with the same names. Disclaimer -- I haven't tested any of this so I leave it to other to point out any errors in logic. Since Kyle mentioned problems with the cat command, the "type" command will can be considered equivalent at a windows command prompt Let me know if you have any questions. kyle On Wed, Nov 22, 2017 at 8:18 AM, Renate Morgenstern <[log in to unmask]> wrote: > Good day,I could not see the suggested solution by Kyle Bannerjee with > the cat command. Possibly he sent it to you directly?If you still have > it please forward it to me.ThanksRenate Morgenstern > > Thanks, everyone, for taking the time to reply to my question! I > > liked the > > simplicity of Kyle Bannerjee's command line suggestion, but stumbled > > over > > how to get the "cat" command to work on my Windows machine and > > couldn't > > figure out how to properly implement GnuWin32, so I went with a > > variation > > of Hannah's solution, using this formula in Excel: > > > > =IF(COUNTIF($C:$C, $A2)=0, "No", "Match!") > > > > On Fri, Nov 10, 2017 at 4:16 PM, Kyle Breneman <[log in to unmask] > > om> > > wrote: > > > > > I have 2 Excel files, each with a column of barcodes. I am > > > supposed to > > > determine which, if any, of the barcodes in the first file are also > > > present > > > in the second file. Is writing a short Python program the best way > > > to do > > > this, or is there a more efficient way? (There are about 300 items > > > in the > > > first file and about 1,000 items in the second file.) > > > > > > Regards, > > > Kyle > > > > -- > > > > > > > > > > > Renate Morgenstern > > Tel.: +264 61 242124 > > Cell: +264 81 2910284 > > Fax: 088637518 > > Windhoek, Namibia >