Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How print evencolumns using awk ?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How print evencolumns using awk ?
# 1  
Old 06-04-2017
How print evencolumns using awk ?
I have a big file (with 200k rows and 10k columns).
How can I print all even columns of this file and also keep the first column?

input
Code:
a    1    a    10    a    11    a    12
b    2    b    30    b    22    b    33

output
Code:
a       1       10      11      12
b       2       30      22      33

Last edited by quincyjones; 06-04-2017 at 02:12 PM..
# 2  
Old 06-04-2017
Any attempts / ideas / thoughts from your side?
# 3  
Old 06-04-2017
I was using this that prints everything in one column

Code:
awk '{ for (i=1;i<=NF;i+=2) print $i }'

# 4  
Old 06-04-2017
That's because print always prints an entire line including the RS char, usually <LF> (\n, 0x0A). Did you consider using the "print formatted" printf command? And, for your desired result, you need to output field 1, and then every other field starting from field 2.
# 5  
Old 06-04-2017
Hello quincyjones,

Could you please try following and let me know if this helps you.
Code:
awk '{printf("%s ",$1);for(i=2;i<=NF;i+=2){printf("%s ",$i)};print ""}'   Input_file

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
quincyjones
# 6  
Old 06-04-2017
Please be aware that your input file has DOS line terminators (<CR>, \r, ^M, 0x0D), so the result you see will not be exactly what you want. Either create a correct *nix text file with your application / editor, or remove the <CR> when processing the file.
# 7  
Old 06-04-2017
updated. The file should be tab delimited.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk: Print count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152... (2 Replies)
Discussion started by: siramitsharma
2 Replies

2. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

3. Shell Programming and Scripting

AWK print AWK command

awk '{print "awk '{sub(/pdb_00/,"pdb_"$0"_00"); print}' pdb_"$0"_00.namd > tempo"; print "mv tempo pdb_"$0"_00.namd"}' datA2.dat > copy_script2.bash This works when trying to print 'sed etc. etc' but if I switch to using AWK to print a set of AWK commands it doesn't work... e.g. this... (3 Replies)
Discussion started by: chrisjorg
3 Replies

4. UNIX for Advanced & Expert Users

awk print help

In this: $ awk '{ print "var is", var }' var=TEST file1 What does the print part do? { print "var is", var } (4 Replies)
Discussion started by: cokedude
4 Replies

5. Shell Programming and Scripting

Print using awk

Hi.. I have two files. contents of the files are as below. header1.dat ------------- This is a header record. header2.dat ------------- This is a header record. Date:2011-01-05 I am executing the below scripts. HEADER1=`cat header1.dat` HEADER2=`cat header2.dat` awk 'BEGIN... (2 Replies)
Discussion started by: 46019
2 Replies

6. Shell Programming and Scripting

print through AWK

Hi friends I need one help from you . I want to print name='JACK' through . how can i make it . awk '{print "name=jack"}' it ll print name=JACK (6 Replies)
Discussion started by: imipsita.rath
6 Replies

7. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

8. Shell Programming and Scripting

Awk and print help

Hello I have a log file like so 2009-01-15 17:55:06 H=host-216-153-217-114.spr.choiceone.net :30675 I=:25 F=<> rejected RCPT <feast@test.co.uk>: DNSBL listed at sbl-xbl.spamhaus.org What I am trying to do is be able to print x amount of columns after a certain part of the line say F= grep... (1 Reply)
Discussion started by: casseyjon
1 Replies

9. Shell Programming and Scripting

awk and print

Hi What is the correct syntax for use a variable value within a print sentence : Example: VAR1=$1 VAR2=$2 ls -l $VAR2/*.LOG | grep -v $VAR1 | nawk -F " " '{ print "mv "$9 " /backup/BACKUP/backup_db_type/$VAR1_arch/."}' > move_arch_des.sh Is this case i need to print $VAR1 within... (3 Replies)
Discussion started by: osymad
3 Replies

10. Shell Programming and Scripting

How do I get awk to print a " in it's print part?

The line is simple, use " '{ print $1"]"$2"\"$3THE " NEEDS TO GO HERE$4 }' I've tried \", "\, ^" and '"" but none of it works. What am I missing? Putting in the [ between $1 and $2 works fine, I just need to do the same with a ". Thanks. (2 Replies)
Discussion started by: LordJezo
2 Replies
Login or Register to Ask a Question