Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File comparisons

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File comparisons
# 1  
Old 08-15-2014
File comparisons
Hi all,

I want to compare two files based on column value
Kindly help me
Code:
a.txt
123,ABCD
456,DEF
789,SDF

Code:
b.txt
123,KJI
456,LMN
321,MJK
678,KOL

Output file should be like
Common on both files

Code:
c.txt
123,ABCD,KJI
456,DEF,LMN

Present in one file but not in 2nd file
Code:
789,SDF

Present in 2nd file but not in first file
Code:
321,MJK
678,KOL

Last edited by rbatte1; 08-15-2014 at 01:05 PM..
# 2  
Old 08-15-2014
What have you tried?
# 3  
Old 08-15-2014
I tried using join and awk both but didnt work
I have only basic knowledge of awk Smilie
# 4  
Old 08-15-2014
In what way did it "not work"? Show exactly what you did, and we can help correct your mistakes.
# 5  
Old 08-15-2014
Code:
join -t, -o "1.1 1.2 2.2" a b

# 6  
Old 08-15-2014
Thank you.

join requires sorted input, so isn't suitable here.

How about this:

Code:
$ awk -F, '{ A[$1]=A[$1] FS $2 ; T[$1]++ } END { for(X in T) if(T[X]>1) { print X A[X] } }' a.txt b.txt
456,DEF,LMN
123,ABCD,KJI

$

This User Gave Thanks to Corona688 For This Post:
aaysa123
# 7  
Old 08-15-2014
can you pls revert for other two requirement as well
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

String regex comparisons

Here is the sample code: str1="abccccc" str2="abc?" if ]; then echo "same string" else echo "different string" fi Given that ? implies 0 or 1 match of preceding character, I was expecting the output to be "different string", but I am seeing "same string". Am I not using the... (3 Replies)
Discussion started by: Rameshck
3 Replies

2. Shell Programming and Scripting

Pair wise comparisons

Hi, I have 25 groups and I need to perform all possible pairwise compariosns between them using the formula n(n-1)/2. SO in my case it will be 25(25-1)/2 which is equal to 300 comparisons. my 25 groups are FG1 FG2 FG3 FG4 FG5 NT5E CD44 CD44 CD44 AXL ADAM19 CCDC80 L1CAM L1CAM CD44... (1 Reply)
Discussion started by: Diya123
1 Replies

3. UNIX for Dummies Questions & Answers

File and if statement comparisons

I'd love to get help on this one please. Ok so say I have a file called README with lines such as this: index:index.html required:file1.1:file2.1:file3.1 I'm having trouble with writing an if statement that compares the items in a list with a file inside README, what I imagine in my head... (7 Replies)
Discussion started by: mistsong1
7 Replies

4. UNIX for Dummies Questions & Answers

Date comparisons

Hi, I want to perform a simple date comparisons, i.e. select all files modified after a certain date (say 12-feb-2011) I do not have the option of creating a file and using find's -newer option. Any simple way to do this? I can do this by reading the stat command's output and comparing... (10 Replies)
Discussion started by: jawsnnn
10 Replies

5. Shell Programming and Scripting

String comparisons

Can someone please tell me what is wrong with this stings comparison? #!/bin/sh #set -xv set -u VAR=$(ping -c 5 -w 10 google.com | grep icmp_req=5 | awk '{print $6}') echo I like cookies echo $VAR if "$VAR" == 'icmp_req=5' then echo You Rock else echo You Stink fiThis is the error.... (6 Replies)
Discussion started by: cokedude
6 Replies

6. UNIX for Dummies Questions & Answers

Command comparisons

Hi guys, Im trying to figure out what is the difference between using a | and the command xargs ... examples of usage: 1) ls * | wc -w => this gives you the number of files in the current directory including all subdirectories 2) find . “*.log” | xargs grep ERROR => this gives... (6 Replies)
Discussion started by: avidrunner
6 Replies

7. Shell Programming and Scripting

Best practice for bracket comparisons?

So, I have no formal higher education in programming at all and am self taught. I am now wondering what would be considered best practices? Like should I hard code a variable, then compare it to what I want to know or achieve, or should I just put the commands with in the brackets? Example, a... (5 Replies)
Discussion started by: tlarkin
5 Replies

8. Shell Programming and Scripting

numeric range comparisons

I have two files.And a sort of matrix analysis. Both files have a string followed by two numbers: File 1: A 2 7 B 3 11 C 5 10 ...... File 2: X 1 10 Y 3 5 Z 5 9 What I'd like to do is for each set of numbers in the second file indicate if the first or second number (or both) in... (7 Replies)
Discussion started by: dcfargo
7 Replies

9. UNIX for Dummies Questions & Answers

Can grep do numerical comparisons?

Say for example I have a list of numbers.. 5 10 13 48 1 could I use grep to show only those numbers that are above 10? For various reasons I can only use grep... not awk or sed etc. (7 Replies)
Discussion started by: Uss_Defiant
7 Replies

10. Shell Programming and Scripting

Script to automate file comparisons

Hi, I need a script that loops through all the files two directories passed to it via parameter, and if two files have the same name, do a cmp comparison on the files. If the files are different, output the specifics returned by cmp. What's the best way to go about writing this, as I am a... (6 Replies)
Discussion started by: herman404
6 Replies
Login or Register to Ask a Question