sed script to read only columns 4 to 6 in output database

cranium2004 · 02-21-2006, 03:17 AM

hello,
I have a application that outputs data in 6 columns but i want only col 4 to 6 information how can i do that?

slackie1000 · 02-21-2006, 03:39 AM

hi there,
why sed??

Code:

awk '{print $4 $5 $6}' $your_output

should be fine.
you can send your output to "pipe" as well.
regards,
slackie1000

furquan · 02-21-2006, 03:41 AM

You could do this with awk to print column 4&6

Quote:

awk '{print $4, $6} filename

cranium2004 · 02-21-2006, 03:44 AM

hi,
No its not working for what i want
eg. if i give

Quote:

ls -lrt | awk '{print $4 $5 $6}'

in /etc and i got
root93Feb
root171830Feb
root70Feb
root804Feb

which is not correct
Also how can i include headers(i mean first line ststic in output)?

furquan · 02-21-2006, 03:54 AM

you need to seperate your print statments with a comma (,)

Quote:

ls -lrt | awk '{print $4, $5, $6}'

not sure what you mean by headers.

cranium2004 · 02-21-2006, 04:02 AM

hi,
thanks but what i have to do so that output will come proper aligned.
what i get is
root 355 Feb
root 93 Feb
root 171830 Feb
root 70 Feb
root 804 Feb

which is not aligned to columns starting at some distance

slackie1000 · 02-21-2006, 04:06 AM

hi there,

Quote:

Originally Posted by cranium2004

hi,
thanks but what i have to do so that output will come proper aligned.
what i get is
root 355 Feb
root 93 Feb
root 171830 Feb
root 70 Feb
root 804 Feb

which is not aligned to columns starting at some distance

next time you can elaborate better your question in the first post..
the following quick and dirty code ..

Code:

awk '
begin
{
printf("%6s %6s %6s",$4,$5,$6)
} ' $some_file

will format the output for you...
regards,
slackie1000

jschiwal · 02-21-2006, 04:06 AM

Awk has a printf function that you can use to provide the formatting you want.

furquan · 02-21-2006, 04:08 AM

It is aligned, If you notice the file size for FEB is larger than any other file and hence it looks out of place.

cranium2004 · 02-21-2006, 04:15 AM

furguan,
then how can ls -lrt gives proper output?

slakie1000,
how can i use that script? actually it will be good if i will get single command
like ls -lrt | {command to output col 4 to 6}

jschiwal · 02-28-2006, 07:20 AM

You can remove the $somefile from the end if you want to pipe the output of the ls command directly to the awk command.

Another way of extracting certain columns from ls -l is to use the "cut" command.
example:
ls -ld * | tr -s ' ' | cut -d' ' -f5,8 --output-delimiter=" "
( note: for the output delimiter I pressed CNTRL-v [TAB] )
The tr command removes duplicate spaces between each field. The cut command then extracts fields 5 and 8. A tab is used in between the size and name on the output. The cut and tr commands are a lot smaller than awk, 34k vs 226k but my example uses 3 commands instead of two. Using a wildcard at the end of the ls command avoids the initial total line.