Sponsored Content
Top Forums Shell Programming and Scripting find difference in file column... Post 302307319 by radoulov on Wednesday 15th of April 2009 05:31:00 AM
Old 04-15-2009
Code:
awk 'NR == 1 { print; next }
{ f = $4; for (i=5; i<=NF; i++) 
  if ($i != f) { print; break } 
  }' infile

With some grep implementations:

Code:
egrep  -v '(        [^      ]*)\1\1\1$' infile

The tab is entered ^V<TAB>

Last edited by radoulov; 04-15-2009 at 06:42 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script to compare first column of two files and find difference

Hi, I want to write a script which will compare the 1st column of both the files and will give the difference. e.g:- my 1st file contains: 89 /usr 52 /usr/local 36 /tmp 92 /opt 96 /home 27 /etc/opt/EMCom 1 ... (3 Replies)
Discussion started by: adityam
3 Replies

2. Shell Programming and Scripting

Calculate difference between consecutive data points in a column from a file

Hi, I have a file with one column data (sample below) and I am trying to write a shell script to calculate the difference between consecutive data valuse i.e Var = Ni -N(i-1) 0.3141 -3.6595 0.9171 5.2001 3.5331 3.7022 -6.1087 -5.1039 -9.8144 1.6516 -2.725 3.982 7.769 8.88 (5 Replies)
Discussion started by: malandisa
5 Replies

3. Shell Programming and Scripting

Script to find difference between 2 files by column

Hi , i am newbie to shell scripting and am trying to do the below job, A shell script to be run with a command like sh Compare.ksh file1.txt file2.txt 1 2 > file3.txt 1 2-are the key columns Consider the delimiter would be Tab or comma File 1: SK TEST NAME MATHS PHYSICS 21 1... (1 Reply)
Discussion started by: shakthi666
1 Replies

4. Homework & Coursework Questions

Script to find difference between 2 files by column

Hi , i am newbie to shell scripting and am trying to do the below job, A shell script to be run with a command like sh Compare.ksh file1.txt file2.txt 1 2 > file3.txt 1 2-are the key columns Consider the delimiter would be Tab or comma File 1: SK TEST NAME MATHS PHYSICS 21 1 AAA... (1 Reply)
Discussion started by: shakthi666
1 Replies

5. Shell Programming and Scripting

Difference of the same column when two other column matches and one column differs less than 1 hour

This is my input file : # cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9 This is the required output ... (1 Reply)
Discussion started by: Lakshmikumari
1 Replies

6. Shell Programming and Scripting

Difference between 2 files, one with 1 column and 2nd file with multiple columns

Hi, I need to find the difference between 2 files in unix and write the result in the new file File1: A B File2: X 123 hajkd Y 345 adjfka A 123 djafjhd B 678 dsndjks Output file: X 123 hajkd Y 345 adjfka Thanks. (6 Replies)
Discussion started by: nani1984
6 Replies

7. Shell Programming and Scripting

I want to find the difference between two files, only for the header (column names)

Hi All, I want to find the difference between two files, by checking only the headers (column names) and report if any new column is added in the latest file. For Ex: If the file "declartion.txt has these columns url;image;id;showcase_id;showcase_name and the actual file "feed.txt" has... (34 Replies)
Discussion started by: Praveen Pandit
34 Replies

8. UNIX for Dummies Questions & Answers

Find the timestamp difference between two different colums in a file

Sample Input File 2014/10/09 CDE876172588765 00:09:45 00:10:10 200 200 11.7093 2014/10/09 CDE366134588757 01:04:34 01:04:54 210 210 9.8898 2014/10/09 CDE765172345745 03:05:46 03:06:01 100 100 10.0601 2014/10/09 ... (8 Replies)
Discussion started by: rpm120
8 Replies

9. UNIX for Beginners Questions & Answers

UNIX utility to find difference in folder, file and contents of file against a base version

Hi, I am trying to find out whether there are any Unix utilities that compares folders, files and contents within the file and provides a comprehensive report. The comparison can be against base version of a folder and file with content. Can you please let me know of such a utility? Thanks,... (6 Replies)
Discussion started by: Sripathi_ks
6 Replies

10. UNIX for Beginners Questions & Answers

awk code to find difference in second file which is not present in first file .

Hi All, I want to find difference between two files and output only lines which are not present in second file .I am using awk and I am getting only the first difference but I want to get all the lines which are not present in file2 .Below is the code I am using . Please help to get the desired... (7 Replies)
Discussion started by: srinivasrao
7 Replies
pac(8)							      System Manager's Manual							    pac(8)

NAME
pac - Outputs printer/plotter accounting information SYNOPSIS
pac [-cmrs] [-p price] [-P printer] [name] FLAGS
Sorts output according to the computed cost instead of alphabetically according to user. Groups all printing charges for the user speci- fied by name, without regard for the host machine from which printing was invoked. The dollar amount charged per unit of output specified by price. The default dollar amount charged is $0.02 per unit. Specifies the printer for which accounting records are produced. Alterna- tively, the system selects the printer named with the PRINTER environment variable, or the default printer lp0. Reverses the sorted order, so that records are listed alphabetically from z to a, or in descending order by computed cost when this flag is used with the -c flag. Writes printer accounting information to a summary file. You must specify the -P flag and printer name (or synonym) when you use this flag. Output is made to a file that is associated with the af entry for the specified printer in the /etc/printcap file. This file is located in the /usr/adm directory. The file name is usually the af accounting file name, with the letters _sum (summary) appended, for example: /usr/adm/lp2acct_sum. Accounting information is in three unheaded columns in the format: pages/feet machinename:username runs DESCRIPTION
When printer accounting is enabled in the /etc/printcap file, and you use the pac command in a shell script or from the standard input, pac outputs printer/plotter accounting records to the standard output for each user of the printer specified with the -P flag and printer name or for users specified with the name parameter. The unit used for printer accounting is the number of pages printed. However, for raster devices (such typesetters, and plotters) length in feet of print medium (film, for example) is the unit used. Output units are expressed both as the number of units used and the charge in dollars according to the price specified with -p flag and price amount per unit. The printer/plotter accounting output has the following column headings and format: Login pages/feet runs price chicken:rcb 19.00 2 $ 0.38 sardine:jmp 22.00 3 $ 0.44 hunch:lucy 53.00 12 $ 1.06 stovetop:suki 1.00 1 $ 0.02 newspaper:myralou 834.00 202 $ 16.68 wimbledon:nhk 69.00 20 $ 1.38 norfolk:sophie 184.00 17 $ 3.68 There are four fields, each with its own column heading, in each record of the default output produced by the pac command: 1) the machine from which the print command was entered and login name is entered in the Login column; 2) the number of pages or feet of paper output is entered in the page/feet column; 3) the number of times the printer was used is entered in the runs column; and 4) the cost computed at the default or specified price is entered in the price column. EXAMPLES
To print printer/plotter accounting information for all users of default printer lp0 to the standard output device, enter: /usr/sbin/pac Output is sorted alphabetically according to machine name and username. The number of printed pages or feet of output paper used and the charge per foot of paper or page is computed at the default dollar amount of $0.02 per page because no flags are specified. To write accounting records for printer printer1 in a summary file, enter the following line as a superuser or as adm: /usr/sbin/pac -Pprinter1 -s Summary information is written to the file /var/adm/printer1acct_sum. To produce accounting information for users lucy, suki and myralou for pages printed on printer putnam408, enter: /usr/sbin/pac -Pputnam408 lucy suki myralou FILES
Specifies the command path Accounting information summary file. Printer information summary file, where printcap symbol af defines the name of the accounting file. RELATED INFORMATION
Commands: acct(8), acctcms(8), acctcom(8), acctcon(8), acctmerg(8), acctprc(8), printcap(4), runacct(8) delim off pac(8)
All times are GMT -4. The time now is 10:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy