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
> > > >
> > --
> >
> >
> >
|
