edit columns in unix shell script

Shell Programming and Scripting
1

i have a file which if you will open as xls will yield something like this:

Column1 Column2 Column3
ABC CDE EFG
GHI IJK KLM
MNO OPQ QRS

what i want to need is to have this kind of results:

Column1
ABC CDE EFG
GHI IJK KLM
MNO OPQ QRS

and delete the other two columns.

Thanks!

2

what have you tried?

3

so want those column2 and column3 header to be removed??

4

actually, i just used "column1", "column2" and "column3" to show that the original file is in columns. yes, after joining the text in one column, delete the other columns

5

joining in the sense?? they are space seperated right??
just print the column1 in first line and the print rest below that that will looks like your o/p

6

im sorry, but i did'n get that "just print the column1 in first line and the print rest below that that will looks like your o/p".

7

I mean this..

awk 'BEGIN{print "column1"}NR>1{print}' filename
8

thanks! im so happy i got to know this site!

9

yes we are here to help you out..
but please post what have you tried along with the question..
I mean please show your effort towards that..

10

im sorry... ill keep that on mind.. unix is very new to me. im starting to learn it.. Thansk again!

---------- Post updated 06-23-09 at 07:48 AM ---------- Previous update was 06-22-09 at 04:52 PM ----------

hi! regarding this problem... what if i want to edit it the other way?

FILE 1
COLUMN1
ABC DEF
GHI JKL
MNO PQR

i want to make it as:
COLUMN1 COLUMN2
ABC DEF
GHI JKL
MNO PQR

Thanks!

---------- Post updated at 07:49 AM ---------- Previous update was at 07:48 AM ----------

there will be two columns now.

11

What about...

awk 'BEGIN{print "column1,column2"}NR>1{print $1 "," $2}' filename