 |
 |
Thanks. I am using Linux. Will test it. RenateAm 23.11.2017 00:22 schrieb Kyle Banerjee <[log in to unmask]>: > > 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 > > > > > > -- > > > > > >