Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
08-14-2006, 11:55 AM
|
#1
|
LQ Guru
Registered: Dec 2005
Location: Somewhere on the String
Distribution: Debian Wheezy (x86)
Posts: 6,094
|
bash script - remove header row from csv file
I'm trying to write a script to automatically take our company phone directory every month and convert it to a palm database file so I have a complete updated directory with me.
Anyway, the script works great, but there's a row of garbage at the top of the file that I'm stumped by.
I've been googling around trying to figure out how to get rid of it and haven't found what I'm looking for. I'm sure there must be a simple awk or bash command that can just whack off the top row of a file, but I'm struggling to find it.
I can live with it, but I was thinking of releasing the phone directory to the rest of the company and would like it to be pretty flawless before I do so.
|
|
|
08-14-2006, 12:25 PM
|
#2
|
LQ Guru
Registered: Dec 2005
Location: Somewhere on the String
Distribution: Debian Wheezy (x86)
Posts: 6,094
Original Poster
|
Never mind.
Code:
sed '1d' file.txt > file.csv
|
|
|
08-14-2006, 12:26 PM
|
#3
|
Member
Registered: Mar 2006
Location: Fort McMurray, Canada
Distribution: Gentoo ~amd64
Posts: 163
Rep:
|
You want to remove the first line of the file? Here's an awk script:
Code:
awk 'FNR>1{print}' file.txt
|
|
|
08-14-2006, 12:27 PM
|
#4
|
Senior Member
Registered: Aug 2003
Location: Birkenhead/Britain
Distribution: Linux From Scratch
Posts: 2,073
Rep:
|
sed -i '1d' /path/to/filename.txt
|
|
|
08-14-2006, 12:39 PM
|
#5
|
HCL Maintainer
Registered: Jan 2006
Distribution: (H)LFS, Gentoo
Posts: 2,450
Rep:
|
Alternately, sed '2,$p' /path/to/file
|
|
|
08-30-2006, 11:05 AM
|
#6
|
LQ Newbie
Registered: Dec 2004
Location: UK
Distribution: Debian
Posts: 21
Rep:
|
Yet another alternative:
Code:
tail -n+2 /path/to/file > /path/to/output
Test with something like:
Code:
echo -e "foo\nbar\nbaz" | tail -n+2
Last edited by Tim Retout; 08-30-2006 at 11:08 AM.
|
|
|
All times are GMT -5. The time now is 03:13 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|