When someone says, 'I want a programming language in which I need only say what I want done,' give him a lollipop.
I am doing a startup!
Cross-browser testing from your browser!
I have written my fourth book!
Be faster than Larry Wall in the shell!
You're viewing a comment by Haba and its responses.
I have several of csv files, I want to remove the first row (header) and first column as well. This is my code, but it overwrites the original files with no content inside:
for x in *.csv;
sed '1d' $x | cut -d, -f 1 > "$x";
Help would be highly appreciated.
You don't need to loop over files. You can use sed's -i argument. This argument replaces data in-place and rewrites the file, and creates a backup .bak version of the file.
Here's how you do it:
sed -i.bak '1d; s/^[^,]\+,//; s/^\s\+//' *.csv
1d delete the first line and goes to next line.
s/^[^,]\+,// delete everything from the start to the first comma.
s/^\s\+// cleanups any whitespace at the beginning.
(why do I need your e-mail?)
It would be nice if you left your e-mail address. Sometimes I want to send a private message, or just thank for the great comment. Having your e-mail really helps.
I will never ever spam you.
(Your twitter handle, if you have one.)
* use <pre>...</pre> to insert a plain code snippet.
* use <pre lang="lang">...</pre> to insert a syntax highlighted code snippet.
For example, <pre lang="python">...</pre> will insert Python highlighted code.
* use <code>...</code> to highlight a variable or a single shell command.
* use <a href="url" nospam>title</a> to insert links.
<a href="url" nospam>title</a>
* use other HTML tags, such as, <b>, <i>, <blockquote>, <sup>, <sub> for text formatting.
Type the word "rocket_122": (just to make sure you're a human)
Please preview the comment before submitting to make sure it's OK.
Peter Krumins' blog about programming, hacking, software reuse, software ideas, computer security, browserling, google and technology.
Reach me at:
Or meet me on:
Subscribe through an RSS feed:
Subscribe through email:
Enter your email address:
Delivered by FeedBurner
See all top articles
See all downloads
See more detailed list of recent articles
See more detailed category information
See more detailed list of all articles