To Remove The Header FIle

vootkur · #1 (**permalink**) 06-21-04, 13:49

state Desc
----- ----
TX Texas
MI Michigan

Hi,
I will be getting a file like this with the columns being of fixed width format,i need to load them into Teradata Tables removing the headers.

Any suggestions will be appreciated.

Thanks
vootkur

LKBrwn_DBA · #2 (**permalink**) 06-21-04, 17:13

You could use sed:

sed -n '3,$p' oldfile >newfile

vootkur · #3 (**permalink**) 06-21-04, 17:25

hi lkbrwn,

when i was trying to run ur command its saying
sed:3 illegal option

LKBrwn_DBA · #4 (**permalink**) 06-21-04, 18:08

Quote:

Originally Posted by vootkur

when i was trying to run ur command its saying
sed:3 illegal option

You must be typing something wrong, it works:

$ cat oldfile
state Desc
----- ----
TX Texas
MI Michigan
FL Florida
WA Washington
MN Minesota
$ sed -n '3,$p' oldfile >newfile
$ cat newfile
TX Texas
MI Michigan
FL Florida
WA Washington
MN Minesota
$

Internet Services

Web Development

Digital Marketing

Consumer Tech