Drop a Column from a File - UNIX for Dummies Questions & Answers

Raamc · #1 (**permalink**) 01-09-2008

Hi,

I need to drop a column from a file. My .txt file having 20 columns first column as GroupBy column which is not necessery in further processing. So i need to create a new files without this column.

Please help how to do this?

Thanks,
Raamc

Tytalus · #2 (**permalink**) 01-09-2008

awk '{$1=""}1' file

should work

Raamc · #3 (**permalink**) 01-09-2008

I tested awk '{$1=""}1' file command.
This is just printing 1 space in first column but not removing the first column.
Below is the test data i tested for

I have a file contain data as
"111","000000 305"
...........etc

I want my o/p to be
"000000 305"

If i use above AWK command the o/p coming as
","000000 305

Thanks
Raamc

Tytalus · #4 (**permalink**) 01-09-2008

ok - you need to specify your field seperator:

awk '{FS=",";$1=""}1' file

radoulov · #5 (**permalink**) 01-09-2008

Code:

cut -d, -f2- data

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
To cut entire column from a file and apend it to another file as another column	sakthifire	Shell Programming and Scripting	4	06-25-2008 01:27 AM
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 05:57 AM
Dynamic Drop down boxes	garric	Shell Programming and Scripting	13	10-18-2007 08:54 AM
Drop records with non-numerics in field X	akxeman	Shell Programming and Scripting	3	08-14-2007 09:55 PM
Drop Users	trfrye	UNIX for Dummies Questions & Answers	2	08-31-2005 12:39 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode