count the unique records based on certain columns Post: 302691073

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Record count based on a keyword in the records

Hi, Am having files with many records, i need to count and display the number of records based on the keyword in one of the column of the records. for e.g THE FILE CONTAINS TWO RECORDS LIKE. 200903031143150 0 1236060795054357lessrv1 BSNLSERVICE1 BSNLSERVICE1 ...

2. Shell Programming and Scripting

using awk to count no of records based on conditions

Hi I am having files with date and time stamp as the folder names like 200906051400,200906051500,200906051600 .....hence everyday 24 files will be generated i need to do certain things on this 24 files daily file contains the data like 200906050016370 0 1244141195225298lessrv3 ...

3. Shell Programming and Scripting

awk : extracting unique lines based on columns

Hi, snp.txt CHR_A SNP_A BP_A_st BP_A_End CHR_B BP_B SNP_B R2 p-SNP_A p-SNP_B 5 rs1988728 74904317 74904318 5 74960646 rs1427924 0.377333 0.000740085 0.013930081 5 ...

4. UNIX for Dummies Questions & Answers

How to count specific columns and merge with unique ones?

Hi. I am not sure the title gives an optimal description of what I want to do. I have several text files that contain data in many columns. All the files are organized the same way, but the data in the columns might differ. I want to count the number of times data occur in specific columns,...

5. Shell Programming and Scripting

Print unique records in 2 columns using awk

Is it possible to print the records that has only 1 value in 2nd column. Ex: input awex1 1 awex1 2 awex1 3 assww 1 ader34 1 ader34 2 output assww 1

6. Shell Programming and Scripting

Find and count unique date values in a file based on position

Hello, I need some sort of way to extract every date contained in a file, and count how many of those dates there are. Here are the specifics: The date format I'm looking for is mm/dd/yyyy I only need to look after line 45 in the file (that's where the data begins) The columns of...

7. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this?

8. Shell Programming and Scripting

Merge records based on multiple columns

Hi, I have a file with 16 columns and out of these 16 columns 14 are key columns, 15 th is order column and 16th column is having information. I need to concate the 16th column based on value of 1-14th column as key in order of 15th column. Here are the example file Input File (multiple...

9. Shell Programming and Scripting

Insert Columns before the last Column based on the Count of Delimiters

Hi, I have a requirement where in I need to insert delimiters before the last column of the total delimiters is less than a specified number. Say if the delimiters is less than 139, I need to insert 2 columns ( with blanks) before the last field awk -F '�' '{ if (NF-1 < 139)} END { "Insert 2...

LEARN ABOUT OSX

exim_convert4r4

EXIM_CONVERT4R4(8)					      System Manager's Manual						EXIM_CONVERT4R4(8)

NAME

       exim_convert4r4 - Convert Exim configuration from v3 to v4 format

SYNOPSIS

       exim_convert4r4

DESCRIPTION

       This  script  is provided to assist in updating Exim configuration files.  It reads an Exim 3 configuration file on the standard input, and
       writes a modified file on the standard output.  It also writes comments about what it has done to the standard error file.  It assumes that
       the input is a valid Exim 3 configuration file.	A typical call to the conversion script might be

       exim_convert4r4 < /etc/exim/exim.conf > /etc/exim4/exim4.conf.new

       The output file MUST be checked and tested before trying to use it on a live system.  The conversion script is just an aid which does a lot
       of the "grunt work".  It does not guarantee to produce an Exim 4 configuration that behaves exactly the same as the Exim 3 configuration it
       reads.

       Each  option  change  in  the new file is preceded by an identifying comment.  In fact, the conversion script tends to make quite a mess of
       your configuration, and you should expect to go through it afterwards and tidy it up by hand.

       Unless you are running a very straightforward configuration, the automatic conversion is likely to generate  a  non-optimal  configuration.
       You should not only check it thoroughly, but also run as many tests as you can, to ensure that it is working as you expect.  In particular,
       you should test address routing, using -bt and -bv, and the policy controls, using -bh.	If possible, you should also do  some  live  tests
       (i.e. send and receive some messages) before putting Exim 4 into service.

       If  you	have a very complicated configuration, it is possible that exim_convert4r4 will break it in some situations, which is why thorough
       testing is strongly recommended.

BUGS

       This manual page needs a major re-work. If somebody knows better groff than us and has more experience in writing manual pages, any patches
       would be greatly appreciated.

SEE ALSO

       exim(8), the files in /usr/share/doc/exim4-base/, especially Exim4.upgrade.gz

AUTHOR

       This  manual  page  was	stitched together from Exim4.upgrade by Andreas Metzler <ametzler at downhill.at.eu.org>, for the Debian GNU/Linux
       system (but may be used by others).

								  March 26, 2003						EXIM_CONVERT4R4(8)