Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Filtering records of a csv file based on a value of a column
Top Forums UNIX for Beginners Questions & Answers Filtering records of a csv file based on a value of a column Post 303030348 by sunilmudikonda on Friday 8th of February 2019 09:39:16 AM
Old 02-08-2019
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 filtering is

Code:
user,user,user,Active
user,user,user,Arvhived
user,user,user,Active
user,user,user,Arvhived
user,user,user,Active
user,user,user,Arvhived
user,user,user,Active
user,user,user,Arvhived
user,user,user,Active
user,user,user,Arvhived
user,user,user,Active
user,user,user,Arvhived

Can some one please help me.

Many Thanks,

Best Regards,
Sunil.
 

10 More Discussions You Might Find Interesting

1. 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 ... (4 Replies)
Discussion started by: risk_sly
4 Replies

2. Shell Programming and Scripting

filtering records based on numeric field value in 8th position

I have a ";" delimited file.Whcih conatins a number fileds of length 4 charcters in 8th position But there is a alphanumeric charcters like : space, ";" , "," , "/" , "23-1" , "23 1" , "aqjhdj" , "jun-23" , "APR-04" , "4:00AM" , "-234" , "56784 ", "." , "+" "_" , "&" , "*" , "^" , "%" , "!"... (2 Replies)
Discussion started by: indusri
2 Replies

3. 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 Replies)
Discussion started by: G.K.K
5 Replies

4. Shell Programming and Scripting

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

Hi Gurus, I am struggling with nawk command where i am processing a file based on columns. Here is the sample data file. UM113570248|24-AUG-11|4|man1|RR211 Alert: Master Process failure |24-AUG-11 UM113570624|24-AUG-11|4|man1| Alert: Pattern 'E_DCLeDAOException' found |24-AUG-11... (7 Replies)
Discussion started by: usha rao
7 Replies

5. UNIX for Dummies Questions & Answers

Filtering records from 1 file based on some manipulation doen on second file

Hi, I am looking for an awk script which should help me to meet the following requirement: File1 has records in following format INF: FAILEd RECORD AB1234 INF: FAILEd RECORD PQ1145 INF: FAILEd RECORD AB3215 INF: FAILEd RECORD AB6114 ............................ (2 Replies)
Discussion started by: mintu41
2 Replies

6. Shell Programming and Scripting

Filtering lines for column elements based on corresponding counts in another column

Hi, I have a file like this ACC 2 2 21 aaa AC 443 3 22 aaa GCT 76 1 33 xxx TCG 34 2 33 aaa ACGT 33 1 22 ggg TTC 99 3 44 wee CCA 33 2 33 ggg AAC 1 3 55 ddd TTG 10 1 22 ddd TTGC 98 3 22 ddd GCT 23 1 21 sds GTC 23 4 32 sds ACGT 32 2 33 vvv CGT 11 2 33 eee CCC 87 2 44... (1 Reply)
Discussion started by: polsum
1 Replies

7. Shell Programming and Scripting

Filtering first file columns based on second file column

Hi friends, I have one file like below. (.csv type) SNo,data1,data2 1,1,2 2,2,3 3,3,2 and another file like below. Exclude data1 where Exclude should be treated as column name in file2. I want the output shown below. SNo,data2 1,2 2,3 3,2 Where my data1 column got removed from... (2 Replies)
Discussion started by: ks_reddy
2 Replies

8. Shell Programming and Scripting

Pick the column value based on another column from .csv file

My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated. Main imp point, in my .csv file, third column is having price value with comma (1,20,300), it has... (2 Replies)
Discussion started by: Ganesh L
2 Replies

9. Shell Programming and Scripting

Get maximum per column from CSV file, based on date column

Hello everyone, I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this: 20170628-23:25:01,1,0,0,1,1,1,1,55,55,1 20170628-23:30:01,1,0,0,1,1,1,1,56,56,1 20170628-23:35:00,1,0,0,1,1,2,1,57,57,2 20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies

10. Shell Programming and Scripting

Filter duplicate records from csv file with condition on one column

I have csv file with 30, 40 columns Pasting just three column for problem description I want to filter record if column 1 matches CN or DN then, check for values in column 2 if column contain 1235, 1235 then in column 3 values must be sequence of 2345, 2345 and if column 2 contains 6789, 6789... (5 Replies)
Discussion started by: as7951
5 Replies

LEARN ABOUT NETBSD

userinfo

USERINFO(8)						    BSD System Manager's Manual 					       USERINFO(8)

NAME

     userinfo -- displays user information

SYNOPSIS

     userinfo [-e] user

DESCRIPTION

     The userinfo utility retrieves the user information from the system.  The userinfo utility is only available if built with EXTENSIONS.  See
     user(8) for more information.

     The following command line option is recognised:

     -e      Return 0 if the user exists, and non-zero if the user does not exist, on the system.  No information is displayed.  This form of the
	     command is useful for scripts which need to check whether a particular user name or uid is already in use on the system.

     The user argument may either be a user's name, or a uid.

EXIT STATUS

     The userinfo utility exits 0 on success, and >0 if an error occurs.

SEE ALSO

     passwd(5), group(8), user(8), useradd(8), userdel(8)

HISTORY

     The userinfo utility first appeared in NetBSD 1.5.  It is based on the addnerd package by the same author.

AUTHORS

     The userinfo utility was written by Alistair G. Crooks <agc@NetBSD.org>.

BSD
								 November 16, 2005							       BSD
All times are GMT -4. The time now is 05:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy