header and tailer sequential file

[yogadeep]

hey how can i remove headers and tails from a sequential file
i have three lines as headers and 4 lines are tails.........

[kumar_s]

Hi and Welcome Aboard :D !!!

"First line is column name" option available in Format tab will avoid the Header to be read. To avoid you may use Filter option and tail command to skip the last row.

[ray.wurlod]

Does your UNIX support +3 option for the head command and the +4 option for the tail command? If so, you have a very easy filter you could use to get the detail rows only.

"First line is column names" will ignore only one row, not three.

[kumar_s]

i have three lines as headers and 4 lines are tails.........

Yeah, didn't observed this properly.

[ray.wurlod]

... or even as a filter command (without the filename) in a Sequential File stage, which will then read the stdout of sed

[DSguru2B]

There are a bunch of sed one liners that can be found on google. Search for 'em.

[kumar_s]

If "head +" option didn't work with the first option suggested by Ray, then the following can be used.

Code: Select all

head -$(expr $(wc -l filename | awk '{ print $1 }') \- 4) filename | tail +4

[ganesh123]

use:

Code: Select all

sed '1,3 d' f | sed -e :a -e '$d;N;2,4ba' -e 'P;D'