awk Matching Columns - Am I missing something? Post: 303024179

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed search lines in file1 matching columns in file2

Hi All, as you can see I'm pretty new to this board. :D I'm struggling around with small script to search a few fields in another file. Basically I have file1 looking like this: 15:38:28 sz:10001 pr:14.16 15:38:28 sz:10002 pr:18.41 15:38:29 sz:10003 pr:19.28 15:38:30 sz:10004...

2. Shell Programming and Scripting

using command line arguments as columns for pattern matching using awk

Hi, I wish to use a column, as inputted by a user from command line, for pattern matching. awk file: { if($1 ~ /^8/) { print $0> "temp2.csv" } } something like this, but i want '$1' to be any column as selected by the user from command line. ...

3. Shell Programming and Scripting

awk - Matching columns between 2 files and reordering results

I am trying to match 4 colums (first_name,last_name,dob,ssn) between 2 files and when there is an exact match I need to write out these matches to a new file with a combination of fields from file1 and file2. I've managed to come up with a way to match these 2 files based on the columns (see below)...

4. Shell Programming and Scripting

Find min.max value if matching columns found using AWK

Input_ File : 2 3 4 5 1 1 0 1 2 1 -1 1 2 1 3 1 3 1 4 1 6 5 6 6 6 6 6 7 6 7 6 8 5 8 6 7 Desired output : 2 3 4 5 -1 1 4 1 6 5 6 8 5 8 6 7

5. Shell Programming and Scripting

Help with awk Matching columns from two files

Hello, I have two files as following: #bin chrom chromStart chromEnd name score strand observed 585 chr2 29442 29443 rs4637157 0 + C/T 585 chr2 33011 33012 rs13423995 0 + A/G 585 chr2 34502 34503 rs13386087 0 + ...

6. Shell Programming and Scripting

awk to copy previous line matching a particular columns

Hello Help, 2356798 7689867 999 000 123678 20385907 9797 666 17978975 87468976 968978 98798 I am trying to have out put which actually look for the third column value of 9797 and then it insert line there after with first, second column value exactly as the previous line and replace the third...

7. Shell Programming and Scripting

awk split columns after matching on rows and summing the last column

input: chr1 1 2 3 chr1 1 2 4 chr1 2 4 5 chr2 3 6 9 chr2 3 6 10 Code: awk '{a+=$4}END{for (i in a) print i,a}' input Output: chr112 7 chr236 19 chr124 5 Desired output: chr1 1 2 7 chr2 3 6 19 chr1 2 4 5

8. Shell Programming and Scripting

awk - matching on 2 columns for differents lines

Given this file (I separated them in block to make my explanation clearer): 92157768877;Sof_deme_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 92157768877;Sof_trav_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 91231838895;Sof_deme_faible_Email_am;EMAIL;26/01/2015;1 0;0...

9. Shell Programming and Scripting

Merging multiple lines to columns with awk, while inserting commas for missing lines

Hello all, I have a large csv file where there are four types of rows I need to merge into one row per person, where there is a column for each possible code / type of row, even if that code/row isn't there for that person. In the csv, a person may be listed from one to four times...

10. Shell Programming and Scripting

awk merge matching columns

I know I'm not the first one asking this but my code still does not work: File 1: gi|1283| tRNAscan exon 87020 88058 . - . transcript_id "Parent=tRNA-Tyr5.r01"; gi|3283| tRNAscan exon 97020 97058 . + . transcript_id "Parent=tRNA-Tyr6.r01"; gi|4283| rRNAscan exon 197020 197058 . - . transcript_id...

LEARN ABOUT DEBIAN

miniunzip

miniunzip(1)						      General Commands Manual						      miniunzip(1)

NAME

       miniunzip - uncompress and examine ZIP archives

SYNOPSIS

       miniunzip [-exvlo] zipfile [ files_to_extract ] [-d tempdir]

DESCRIPTION

       minizip	is  a  simple tool which allows the extraction of compressed file archives in the ZIP format used by the MS-DOS utility PKZIP.	It
       was written as a demonstration of the zlib(3) library and therefore lack many of the features of the unzip(1) program.

OPTIONS

       A number of options are supported.  With the exception of -d tempdir these must be supplied before any other arguments and are:

       -l , --v
	      List the files in the archive without extracting them.

       -o     Overwrite files without prompting for confirmation.

       -x     Extract files (default).

       The zipfile argument is the name of the archive to process. The next argument can be used to specify a single file to extract from the  ar-
       chive.

       Lastly, the following option can be specified at the end of the command-line:

       -d tempdir
	      Extract the archive in the directory tempdir rather than the current directory.

SEE ALSO

       minizip(1), zlib(3), unzip(1).

AUTHOR

       This  program was written by Gilles Vollant.  This manual page was written by Mark Brown <broonie@sirena.org.uk>. The -d tempdir option was
       added by Dirk Eddelbuettel <edd@debian.org>.

								    Nov 7, 2001 						      miniunzip(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed search lines in file1 matching columns in file2

Discussion started by: floripoint

2. Shell Programming and Scripting

using command line arguments as columns for pattern matching using awk

Discussion started by: invinclible0009

3. Shell Programming and Scripting

awk - Matching columns between 2 files and reordering results

Discussion started by: ambroze

4. Shell Programming and Scripting

Find min.max value if matching columns found using AWK

Discussion started by: vasanth.vadalur