Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: [HELP] - Delete rows on a CSV file
Top Forums Shell Programming and Scripting [HELP] - Delete rows on a CSV file Post 302327471 by Sadarrab on Sunday 21st of June 2009 07:28:02 PM
Old 06-21-2009
Java
Quote:
Originally Posted by ghostdog74
Code:
# awk 'FNR==NR{a[$0];next}!($0 in a)' file2 file1
1
4

So i made this...

# awk 'FNR==NR{a[$0];next}!($0 in a)' file2 file1 > file3

I get all the numbers that are not repeaded between file2 and file1 and i write them in a new file.
But i didn't urderstand what this means "'FNR==NR...".

Thanks a lot.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to delete particular rows from a file

Hi I have a file having 1000 rows. Now I would like to remove 10 rows from it. Plz give me the script. Eg: input file like 4 1 4500.0 1 5 1 1.0 30 6 1 1.0 4500 7 1 4.0 730 7 2 500000.0 730 8 1 785460.0 45 8 7 94255.0 30 9 1 31800.0 30 9 4 36000.0 30 10 1 15000.0 30... (5 Replies)
Discussion started by: suresh3566
5 Replies

2. Shell Programming and Scripting

Deleting rows from csv file

Hello, I am supposed to process about 100 csv files. But these files have some extra lines at the bottom of the file. these extra lines start with a header for each column and then some values below. These lines are actually a summary of the actual data and not supposed to be processed. These... (8 Replies)
Discussion started by: cobroraj
8 Replies

3. Shell Programming and Scripting

delete rows in a file based on the rows of another file

I need to delete rows based on the number of lines in a different file, I have a piece of code with me working but when I merge with my C application, it doesnt work. sed '1,'\"`wc -l < /tmp/fileyyyy`\"'d' /tmp/fileA > /tmp/filexxxx Can anyone give me an alternate solution for the above (2 Replies)
Discussion started by: Muthuraj K
2 Replies

4. Shell Programming and Scripting

Please do help: Perl Script to pull out rows from a CSV file

I have CSV file that contains data in the format as shown below: ABC, 67, 56, 67, 78, 89, 76, 55 PDR, 85, 83, 83, 72, 82, 89, 83 MPG, 86, 53, 54, 65, 23, 54, 75 .. .. .. .. I want to create a script that will pull out the rows from the above sheet and paste it into another CSV file.... (12 Replies)
Discussion started by: pankajusc
12 Replies

5. Shell Programming and Scripting

How to remove Blank rows in a csv file

Hi, I need help to remove blank rows at the end of file. Sample data: "Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91 "Tønsberg, Brygga Kino SF",Tønsberg,202-1,Tønsberg SF 4,202-1-4 ,,,, ,,,, ,,,, ,,,, Expected data: "Oslo, Symra kino",Oslo,130-7,Symra 1,130-7-91 "Tønsberg, Brygga... (6 Replies)
Discussion started by: cnraja
6 Replies

6. Shell Programming and Scripting

Parsing a CSV file and deleting all rows on condition

Hello list, I am working on a csv file which contains two fields per record which contain IP addresses. What I am trying to do is find records which have identical fields(IP addresses) which occur 4(four) times, and if they do, delete all records with that specific identical field(ip address). ... (4 Replies)
Discussion started by: landossa
4 Replies

7. Shell Programming and Scripting

Copying down first row in to all the below blank rows in a .csv file

Hi All, I have many of files(.csv) of the format given below. Date,Name,Location 04/02/2012,A,India ,B,China ,C,USA Like this I have 1000's of rows and many columns in all my files. I need a shell script to copy down the Date(in this example column1) to the next 2 rows below(in the... (8 Replies)
Discussion started by: ks_reddy
8 Replies

8. Shell Programming and Scripting

Converting rows to columns in csv file

Hi, I have a requirement to convert rows into columns. data looks like: c1,c2,c3,.. r1,r2,r3,.. p1,p2,p3,.. and so on.. output shud be like this: c1,r1,p1,.. c2,r2,p2,.. c3,r3,p3,.. Thanks in advance, (12 Replies)
Discussion started by: Divya1987
12 Replies

9. Shell Programming and Scripting

Bash script help - removing certain rows from .csv file

Hello Everyone, I am trying to find a way to take a .csv file with 7 columns and a ton of rows (over 600,000) and remove the entire row if the cell in forth column is blank. Just to give you a little background on why I am doing this (just in case there is an easier way), I am pulling... (3 Replies)
Discussion started by: MrTuxor
3 Replies

10. UNIX for Beginners Questions & Answers

Get duplicate rows from a csv file

How can i get the duplicates rows from a file using unix, for example i have data like a,1 b,2 c,3 d,4 a,1 c,3 e,5 i want output to be like a,1 c,3 (4 Replies)
Discussion started by: ggupta
4 Replies

LEARN ABOUT HPUX

chsh

chsh(1) 						      General Commands Manual							   chsh(1)

NAME

       chsh - change default login shell

SYNOPSIS

       login-name [shell]

       login-name [shell]

       login-name [shell]

       login-name [shell]

DESCRIPTION

       The command changes the login-shell for a user's login name in the repository (see passwd(1)).

       The  DCE  repository is only available if Integrated Login has been configured; see auth.adm(1M).  If Integrated Login has been configured,
       other considerations apply.  A user with appropriate DCE privileges is capable of modifying a user's shell;  this  is  not  dependent  upon
       superuser privileges.

       If the repository is not specified (as in [login-name]), the login shell is changed in the file only.

       Run after running to make sure the information was processed correctly.

   Notes
       The  command  is  a hard link to the command. When is executed, actually the command gets executed with appropriate arguments to change the
       user login shell in the repository specified in command line. If no repository is specified, the login shell is changed in the file.

   Arguments
	      login-name  A login name of a user.

	      shell	  The absolute path name of a shell.  If the file exists, the new login shell must be listed in that file.  Otherwise, you
			  can specify one of the standard shells listed in the getusershell(3C) manual entry.  If shell is omitted, it defaults to
			  the POSIX shell,

   Options
       The following option is recognized:

	      Specify the repository to which the operation is to be applied.
		     Supported repositories include and

   Security Restrictions
       You must have appropriate privileges to use the optional login-name argument to change another user's login shell.

NETWORKING FEATURES

   NFS
       File can be implemented as a Network Information Service (NIS) database.

EXAMPLES

       To change the login shell for user to the default:

       To change the login shell for user to the C shell:

       To change the login shell for user to the Korn shell in the DCE registry:

WARNINGS

       If two or more users try to write the file at the same time, a passwd locking mechanism was devised.  If this locking  fails  after  subse-
       quent retrying, terminates.

AUTHOR

       was developed by HP and the University of California, Berkeley.

FILES

SEE ALSO

       chfn(1), csh(1), ksh(1), passwd(1), sh(1), sh-posix(1), getusershell(3C), pam(3), passwd(4), shells(4).

																	   chsh(1)
All times are GMT -4. The time now is 11:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy