Printing columns


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Printing columns
# 1  
Old 06-14-2009
Printing columns

Im using awk to print columns. Basically I have a file with like 500 columns and I want to print the 200th-300th column and ignore the rest... how would I do it without putting $200, $201 .... $300

thanks
# 2  
Old 06-14-2009
Hi Guys,

I tried to solve it...

awk '{for (i=2;i<5;i++) print $i;}' 1.txt -- is giving the words in different rows.. so i used this command...

awk '{for (i=2;i<5;i++){r=""} {r=r $i} print $r;}' 1.txt

But it is giving the whole line..
Can anyone tell me where i am going wrong..
# 3  
Old 06-14-2009
Try This :

Code:
awk 'BEGIN { COUNTER=1;
                            FS="|" } 
                          { while ( COUNTER <=100 )
                             {
                            print $COUNTER
                              COUNTER++

                               }
                          COUNTER=1 }' filename

# 4  
Old 06-14-2009
Code:
awk 'BEGIN { min = 200; max = 300 }
{ 
  for (i=min; i<=max; i++)
    printf "%s", $i (i < max ? FS : RS)
    }' infile


With Perl:
Code:
perl -lane'print join " ",@F[200..300]' infile

And, of course, if the field separator is a single character (single space in the example below):

Code:
cut -d\  -f200-300 infile

# 5  
Old 06-14-2009
radoulov,,

Can you point out the mistake in my awk..


awk '{for (i=200;i<300;i++){r=""} {r=r $i} print $r;}' 1.txt
# 6  
Old 06-14-2009
Code:
awk '{for (i=200;i<=300;i++){r=""} {r=r $i} print $r;}' 1.txt

Well,
check the order of esecution:

Code:
awk '{
  for (i=200;i<=300;i++) { # step 1
    r = ""                 # step 1.1
    } 
  { r = r $i }             # step 2
  print $r                 # step 3
  }' 1.txt

Inside the loop only the code in step 1.1 is executed.

I suppose you want something like this:

Code:
awk '{
  for (i=200; i<=300; i++) 
    r = r $i 
  print r; r = ""
  }'

As a side effect you will loose the filed separator.

P.S. You need <= if you want the 300th field to be printed.

HTH
# 7  
Old 06-14-2009
radoulov,

thanks for the help...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Printing multiple columns from a file

Hi, I need just to print the values of second and fourth column from a file # cat dispaly id Name Std Specialist 1 sss X mathematics 2 uyt IX geography 3 vcd X English i tried with some NF command.. I think am wrong.. Is there anyother way to print my requirement (3 Replies)
Discussion started by: Priya Amaresh
3 Replies

2. UNIX for Dummies Questions & Answers

Printing all the values in the middle of two columns

Hi, I have a tab delimited text file with three columns: Input: 1 25734 25737 1 32719 32724 1 59339 59342 1 59512 59513 1 621740 621745 For each row of the text file I want to print out all the values between the second and third columns, including them. The... (3 Replies)
Discussion started by: evelibertine
3 Replies

3. Shell Programming and Scripting

Printing in columns

is there a short one-liner that can print out in columns instead of a long list? as in, instead of: apples oranges cats dogs sky monkey giraffe cups spoons tv cable it'll print something like this (properly indented of course :) ): (9 Replies)
Discussion started by: SkySmart
9 Replies

4. UNIX for Dummies Questions & Answers

Printing columns with header

Hi Gurus, I want to extract certain columns from file 2 and combine with file 1. I am using the following script to extract the columns. $ awk 'FNR>1{print $2, $9, FILENAME}' *.lim > out1 However, this script does not print the titles of the columns 2 and 9. Can somebody help me in... (1 Reply)
Discussion started by: Unilearn
1 Replies

5. Shell Programming and Scripting

Printing Fixed Width Columns

Hi everyone, I have been working on a pretty laborious shellscript (with bash) the last couple weeks that parses my firewall policies (from a Juniper) for me and creates a nifty little columned output. It does so using awk on a line by line basis to pull out the appropriate pieces of each... (4 Replies)
Discussion started by: cixelsyd
4 Replies

6. Shell Programming and Scripting

Comparing Columns and printing the difference from a particular file

Gurus, I have one file which is having multiple columns and also this file is not always contain the exact columns; sometimes it contains 5 columns or 12 columns. Now, I need to find the difference from that particular file. Here is the sample file: param1 | 10 | 20 | 30 | param2 | 10 |... (6 Replies)
Discussion started by: buzzusa
6 Replies

7. UNIX for Dummies Questions & Answers

Perl, printing a string into columns

How can I use Perl to a take a string of 10 characters and print the last five characters of the string in columns 1-5 and the first five in columns 6-10? Result: 0123456789 5 0 6 1 7 2 8 3 9 4 (5 Replies)
Discussion started by: doubleminus
5 Replies

8. UNIX for Dummies Questions & Answers

awk printing all columns after (but including) $n

I am piping an "ls -l" to awk so that all it returns is the file size, date, and file name. The problem is that some files may have spaces in the name so awk is only printing the first word in the file name. I won't know how many space-delimited words are in the filename, so what I want to do is... (2 Replies)
Discussion started by: cassj
2 Replies

9. Shell Programming and Scripting

Printing Columns in Unix

ok. this is a bit of a difficult question but i've been trying to figure this out for quite some time but couldn't. how do I print columns on the screen? like take for instant. using the ls and the file command, how do i print it so i can have the filenames on the left hand side and the... (3 Replies)
Discussion started by: Terrible
3 Replies

10. Shell Programming and Scripting

printing columns

Here's what I wrote: #!/bin/sh d1=`grep Dialtone dialtone | awk '{print $2, $3, $4, $5, $6, $7, $8, $9}'` d2=`grep pstsys dialtone | awk '{print $12}'` echo "$d1 $d2" I expected the result to be this: Dialtone on host 1 slot 13 port 1, pstsys05 Dialtone on host 1 slot 13 port 1,... (3 Replies)
Discussion started by: cdunavent
3 Replies
Login or Register to Ask a Question