Compare line and printing difference Post: 302951561

Sponsored Content

Top Forums Shell Programming and Scripting Compare line and printing difference Post 302951561 by RavinderSingh13 on Friday 7th of August 2015 09:45:06 AM

08-07-2015

Moderator

Hello Wahi,

Could you please try following and let me know if this helps you.

Code:

 awk -F, 'FNR==NR{split($0, A,",");next} {for(i=1;i<=NF;i++){D=$i;for(D in A){delete A[i]}}} END{for(j in A){print A[j]}}' t2 t1

output will be as follows.

Code:

e
f

EDIT: Adding a non one-liner form of solution too.

Code:

awk -F, 'FNR==NR        {
                                split($0, A,",");
                                next
                        }
                        {       for(i=1;i<=NF;i++)      {
                                                                D=$i;
                                                                for(D in A)     {
                                                                                        delete A[i]
                                                                                }
                                                        }
                        }
         END            {       for(j in A)             {
                                                                print A[j]
                                                        }
                        }
         ' t2 t1

Thanks,
R. Singh

Last edited by RavinderSingh13; 08-07-2015 at 10:52 AM.. Reason: Added a non-one liner form of solution now

RavinderSingh13

View Public Profile for RavinderSingh13

Find all posts by RavinderSingh13

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to compare two files and to print the difference

suppose one file P1168S P2150L P85L Q597R R1097C Another file P2150L P85L Q597R R1097C R1379C R1587K Then output shud be R1379C R1587K thanks

2. Shell Programming and Scripting

Compare difference

Hi every body Help required file 1 aaaaa bbbb cccccc dddd ffff File 2 aaaaa,1,ee,44,5t,6y, cccccc, ..... dddd, ..... eeeeee, ..... ffff, ...... ggg, .......

3. Shell Programming and Scripting

Comparing Columns and printing the difference from a particular file

Gurus, I have one file which is having multiple columns and also this file is not always contain the exact columns; sometimes it contains 5 columns or 12 columns. Now, I need to find the difference from that particular file. Here is the sample file: param1 | 10 | 20 | 30 | param2 | 10 |...

4. Shell Programming and Scripting

Columns comparision of two large size files and printing the difference

Hi Experts, My requirement is to compare the second field/column in two files, if the second column is same in both the files then compare the first field. If the first is not matching then print the first and second fields of both the files. first file (a .txt) < 1210018971FF0000,...

5. Shell Programming and Scripting

how to read the contents of two files line by line and compare the line by line?

Hi All, I'm trying to figure out which are the trusted-ips and which are not using a script file.. I have a file named 'ip-list.txt' which contains some ip addresses and another file named 'trusted-ip-list.txt' which also contains some ip addresses. I want to read a line from...

6. Shell Programming and Scripting

Compare two CSV files and put the difference in third file with line no,field no and diff value.

I am having two csv files i need to compare these files and the output file should have the information of the differences at the field level. For Example, File 1: A,B,C,D,E,F 1,2,3,4,5,6 File 2: A,C,B,D,E,F 1,2,4,5,5,6 out put file:

7. UNIX for Dummies Questions & Answers

Printing into two files under difference situation

I want to printing into two files under difference situation. For example, file 1 name.txt >gma-miR172a Glyma02g28845 >gma-miR1513a-3p Glyma02g15840 >gma-miR166a-5p Glyma02g15840 >gma-miR1530 Glyma02g15130 >gma-miR1507a Glyma02g01841 File 2 a.gff Glyma01g07930 ...

8. Shell Programming and Scripting

Compare file1 for matching line in file2 and print the difference in matching lines

Hello, I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from...

9. Shell Programming and Scripting

Compare two variables and print the difference

Hi PRIM_SEQ=`some sql code` and output of PRIM_SEQ is like below 120 130 STB_SEQ=`some sql code` and output of STB_SEQ is like below 115 110 i need to compare this two variables output ( decimal numbers) 1) What I want to do is to compare every number in the PRIM_SEQ with...

10. UNIX for Beginners Questions & Answers

Compare two variables and print the difference

compare two variables and print the difference i have two variables X1=rac1,rac2 Y1=rac2,rac3 output=rac1,rac3 Use code tags to wrap code fragments or data samples.

LEARN ABOUT CENTOS

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to compare two files and to print the difference

Discussion started by: cdfd123

2. Shell Programming and Scripting

Compare difference

Discussion started by: The_Archer

3. Shell Programming and Scripting

Comparing Columns and printing the difference from a particular file

Discussion started by: buzzusa

4. Shell Programming and Scripting

Columns comparision of two large size files and printing the difference

Discussion started by: krao

5. Shell Programming and Scripting

how to read the contents of two files line by line and compare the line by line?

Discussion started by: mjavalkar

6. Shell Programming and Scripting

Compare two CSV files and put the difference in third file with line no,field no and diff value.

Discussion started by: karingulanagara

7. UNIX for Dummies Questions & Answers

Printing into two files under difference situation

Discussion started by: grace_shen

8. Shell Programming and Scripting

Compare file1 for matching line in file2 and print the difference in matching lines

Discussion started by: RasB15

9. Shell Programming and Scripting

Compare two variables and print the difference

Discussion started by: amar1208

10. UNIX for Beginners Questions & Answers

Compare two variables and print the difference

Discussion started by: jhonnyrip

LEARN ABOUT CENTOS

igawk