try http://www.scootersoftware.com... Last edited: 14-Aug-09 04:42 PM

techGuy · Aug 14, 2009 4:37 PM

Just installed and tried it -- still the same issue ..it does the comparison, but only for a single occurrence. I haven't had a chance to look at the options yet though. Thanks! ~@~

Saajha · Aug 14, 2009 4:59 PM

Download the 30 day free trail of arexis merge. This tool works great. http://www.araxis.com/merge/

parajn · Aug 14, 2009 7:07 PM

Have you tried this tool for similar purpose? Will take a look. Thanks! BTW, I was able to get it done on Excel (underrated, but worked great) by playing around with logical comparison formulas. ~@~

Saajha · Aug 18, 2009 12:19 PM

Create two text files. x.txt with abc def def ghi and y.txt with bcd def ijk jkl Issue following commands (at cygwin prompt) //sort and copy unique elements of x to x1 sort -u x.txt > x1.txt //sort and copy unique elements of y to y1 sort -u y.txt > y1.txt //copy lines that appear in the both x1 and y1 to z comm -1 -2 x1.txt y1.txt >z.txt //output lines that appear in x1 only comm -2 -3 x1.txt z.txt //output lines that appear in y1 only comm -2 -3 y1.txt z.txt Works for this limited dataset. Give it a try.

gidilat · Aug 18, 2009 1:34 PM

Thanks @gidilat, for the advice, and welcome to the forum - if you are a new member :-) Just looked through the commands and spotted a minor gotcha.. When you do sort -u and sort the list in order by unique elements, you'd actually get rid of multiple occurrences of each element. Once that's done, it's really a one to one comparison, no? In the above scenario, ALL occurrences of def on list A were eliminated - as they matched def on list B. But if I had, say abc listed twice in list A and did not exist at all in list B, sort -u would remove the second instance of abc in list A, correct? But the goal is to have every single occurrence of abc in list A if it's not present in list B. Thanks again for chiming in. ~@~

Saajha · Aug 18, 2009 4:37 PM

You are changing the goal from "in other words, identify unique strings in each file" to "goal is to have every single occurrence of abc in list A if it's not present in list' A problem needs to defined properly before it can be solved.

gidilat · Aug 18, 2009 7:02 PM

Hmm, so - I said: "...the goal is to have every single occurrence of abc in list A if it's not present in list B" Doesn't that leave each list's strings/elements unique to those of the other list (and hence "...unique strings in each file")? When we compare two files and speak about 'uniqueness', I'd think the reference would be toward uniqueness with respect to each other, and not within oneself. Regardless, I'll buy the fact that 'unique strings in each file with respect to each other' or something similar would've made it little more descriptive. Sorry -- Thanks! So, just for the heck of it - I tried comm without sorting and isolating the unique elements, works just as good as any other alternatives (except Excel) that I tried in the past. It does the comparison, but only gets rid of a single occurrence of the match. ~@~

Saajha · Aug 19, 2009 11:08 AM