I need to filter my data based on 3 different columns.
Two of the columns are unique so it worked if u use something like
However the other column is not unique ..
So basically I want to extract out lines that match only match these 3 criteria : HIGH in column 1, PASS in column 2, 1 and 3 in column 3. Other columns also contain numbers that can include 1 and 3.
how can I use 'awk' on this ? the columns are separated by "\t"
Last edited by Scrutinizer; 02-19-2016 at 04:56 AM..
hi,
i have little pb, i would like make a colums, but my server not recongize "\t" or i write wrong.... and iam little noobs and no know awk...
#!/bin/ksh
#----------------------------------------------------------------------------
# Fichiers : ctrl.sh et ctrl2005.txt ... (6 Replies)
hi all ,
i have three files that contain numbes as the first column .
i want to add these files together so the numbers from the first file is in the first column ; the numbers from the second file in the second column; and the numbers from the third file in the third column .
as an... (5 Replies)
Hi,
I have an urgent task here. I am required to sort a flat file based on multiple columns which are based on the character position in that line. I am restricted to use the character position instead of the space and sort +1 +2 etc to do the sorting.
I understand that there is a previous... (8 Replies)
Hi Everybody.
I need an urgent help, it would be great if somebody will help me out in this regard. See below sample file
1525 805 26 2036 219644. 2598293.
1525 805 126 2327
1525 805 226 ... (6 Replies)
Hi guys,
I usualy am able to google awk stuff but I can't find it so far and there are so many awking gurus here that I will give it a shot.
I want to print $1;$3;"$5 up to the $NF". In other words, I can have 1000 colums, but need to have $5 up to the end.
I started with the idea of... (2 Replies)
I want to rearrange some of my columns in my dat file; how do i do this using a script
Suppose, I have an input file like this:
BASENAME STREETTYPE PREFIX SUFFIX HOUSENUMBER BUILDUP ORDER8 ORDER2 ORDER1 ISOCOUNTRYCODE POSTALCODE
SILVER LAKE RD NW 1135 NEW BRIGHTON RAMSEY MINNESOTA USA 55112... (4 Replies)
Need help to convert the following data
Account name: admin
Role: admin
Description: Administrator
Enabled: Yes
to
Account Name Role Description Enabled
admin admin Administrator Yes
Perl or AWK?
Thanks
San (9 Replies)
Hi all,
I have a text file that has (4) columns. There are about 300 lines on this file. It is a plain text file. I am looking to write a simple script that will read each line from the file and generate another text file. The file looks something like this:
These are the columns:
... (4 Replies)
Hi ,
I am trying to write a part in shell script. I have two files with one column each and would like to output it to a new file giving the records which are different.Pls help experts.
File1
Column name
11
12
13
14
18
File2
Column name
11
12
14
17
19 (2 Replies)
COLRM(1) BSD General Commands Manual COLRM(1)NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO awk(1), column(1), cut(1), paste(1)HISTORY
The colrm command appeared in 3.0BSD.
BSD August 4, 2004 BSD