Deleting Lines from .csv file

#1 (**permalink**) 11-13-2006

Hello All,

I have a .csv file and I have to delete the selcted records stored in a vairable
e.g
echo $lname
7 88 91 94 97 100 103 106
I dont know how to pass the variable name to "sed" for deleting the $lname from a file
can any one help as this is very urgent.

$lname is changing the lines number so there is no fix line number stored in $lname this is upto the file.

aigles · #2 (**permalink**) 11-13-2006

A possible solution using awk :

Code:

awk -v excl=" $lname " '! index(excl, " " NR " ")' csv_file

Jean-Pierre.

#3 (**permalink**) 11-13-2006

Hello Jean,

Thanks for your response. But I am looking to delete those lines which comes under the $lname variable. but your solution is only giving the lines name not what exectly I want.

aigles · #4 (**permalink**) 11-14-2006

Code:

$ cat excl.dat
Input line 1
Input line 2
Input line 3
Input line 4
Input line 5
Input line 6
Input line 7
Input line 8
Input line 9
Input line 10
Input line 11
Input line 12
$ lname='1 5 7 10'
$ awk -v excl=" $lname " '! index(excl, " " NR " ")' excl.dat
Input line 2
Input line 3
Input line 4
Input line 6
Input line 8
Input line 9
Input line 11
Input line 12
$

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Deleting lines from a file	Nirgude07	UNIX for Advanced & Expert Users	11	07-01-2009 02:09 PM
Deleting lines in text file	hern14	UNIX for Dummies Questions & Answers	5	05-16-2008 03:03 PM
Deleting lines in a file	reachsamir	Shell Programming and Scripting	2	05-29-2007 11:17 AM
Deleting last 2 lines from the file.	videsh77	Shell Programming and Scripting	4	04-06-2007 01:14 PM
deleting lines in a log file	BG_JrAdmin	Shell Programming and Scripting	2	08-22-2006 11:12 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by