Nawk script to compare records of a file based on a particular column. Post: 302550524

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Select records based on search criteria on first column

Hi All, I need to select only those records having a non zero record in the first column of a comma delimited file. Suppose my input file is having data like: "0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005" "0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"...

2. UNIX for Dummies Questions & Answers

Filtering records of a file based on a value of a column

Hi all, I would like to extract records of a file based on a condition. The file contains 47 fields, and I would like to extract only those records that match a certain value in one of the columns, e.g. COL1 COL2 COL3 ............... COL47 1 XX 45 ...

3. Shell Programming and Scripting

Compare files column to column based on keys

Here is my situation. I need to compare two tab separated files (diff is not useful since there could be known difference between files). I have found similar posts , but not fully matching.I was thinking of writing a shell script using cut and grep and while loop but after going thru posts it...

4. Shell Programming and Scripting

Removing duplicate records in a file based on single column

Hi, I want to remove duplicate records including the first line based on column1. For example inputfile(filer.txt): ------------- 1,3000,5000 1,4000,6000 2,4000,600 2,5000,700 3,60000,4000 4,7000,7777 5,999,8888 expected output: ---------------- 3,60000,4000 4,7000,7777...

5. Emergency UNIX and Linux Support

[Solved] Extract records based on a repeated column value

Hi guys, I need help in making a command to find some data. I have multiple files in which multiple records are present.. Each record is separated with a carriage return and in each record there are multiple fields with each field separated by "|" what i want is that I want to extract...

6. Shell Programming and Scripting

Removing duplicate records in a file based on single column explanation

I was reading this thread. It looks like a simpler way to say this is to only keep uniq lines based on field or column 1. https://www.unix.com/shell-programming-scripting/165717-removing-duplicate-records-file-based-single-column.html Can someone explain this command please? How are there no...

7. Shell Programming and Scripting

Compare based on column value

Hi Experts, I want to compare 2 text files based on their column values text1 is like prd-1234 yes no yes yes prd-2345 no no no yes prd-6475 yes yes yes no and test 2 is prd-1234 no no no yes prd-2345 yes no no no desired out put as follows prd-1234 1 3 prd-235 1 4 basically it shows...

8. Shell Programming and Scripting

Compare two files based on column

Hi, I have two files roughly 1200 fields in length for each row, sorted on the 2nd field. I need to compare based on that 2nd column between file1 and file2 and print lines that exist in both files into separate files (I can't guarantee that every line in file1 is in file2). Example: File1: ...

9. Shell Programming and Scripting

Compare two csv's with column based

Hi, I am having below two CSV's col_1,col_2,col_3 1,2,4 1,3,6 col_1,col_3,col2,col_5,col_6 1,2,3,4,5 1,6,3,,, I need to compare based on the columns where the mismatch is expected output col_1,col_2,col_3 1,2,4

10. UNIX for Beginners Questions & Answers

Filtering records of a csv file based on a value of a column

Hi, I tried filtering the records in a csv file using "awk" command listed below. awk -F"~" '$4 ~ /Active/{print }' inputfile > outputfile The output always has all the entries. The same command worked for different users from one of the forum links. content of file I was...

LEARN ABOUT DEBIAN

xpl2gpl

XPL2GPL(1)						      General Commands Manual							XPL2GPL(1)

NAME

       xpl2gpl - Convert tcptrace-style xplot input to gnuplot input.

SYNOPSIS

       xpl2gpl [-s] <file_name>

DESCRIPTION

       xpl2gpl	is a utility that converters tcptrace-style xplot input to gnuplot input.  This converter gives a nearly perfect gnuplot reproduc-
       tion of the corresponding xplot graph.

OPTIONS

       -s     Seperate files.  If you wish to plot only some data from the xpl file, you may use the -s option, which generates a bunch  of  data-
	      files filtered based on the color and plotting style.

EXAMPLES

       xpl2gpl foo.xpl

       This  would  produce files by the names "foo.gpl", "foo.datasets" and "foo.labels".  Load the file "file_name.gpl" in gnuplot and it should
       give you the plot.

NOTES

       xpl2gpl is provided for convenience, as gnuplot is more commonly installed than the xplot package  that	tcptrace  typically  expects,  and
       because xplot has not always been available in Debian. If possible, you should consider installing the xplot-xplot.org package and using it
       instead of using xpl2gpl.

AUTHOR

       Avinash Lakhiani (no known email address)

       This manual page was written by Noah Meyerhans <noahm@debian.org> for the Debian project and may be used freely and without restriction	by
       others.

SEE ALSO

       tcptrace(1)

								    Aug 8, 2009 							XPL2GPL(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Select records based on search criteria on first column

Discussion started by: shashi_kiran_v

2. UNIX for Dummies Questions & Answers

Filtering records of a file based on a value of a column

Discussion started by: risk_sly

3. Shell Programming and Scripting

Compare files column to column based on keys

Discussion started by: blackjack101

4. Shell Programming and Scripting

Removing duplicate records in a file based on single column

Discussion started by: G.K.K