Sponsored Content
Full Discussion: add multiple colum using awk
Top Forums Shell Programming and Scripting add multiple colum using awk Post 302207131 by anish19 on Thursday 19th of June 2008 07:53:46 AM
Old 06-19-2008
Bug

Hi thanks for reply but when i am running this command it gives o/p
>cat a.txt
2,3,4,5,6,7,8,9,0,33,44,55,66
3,4,5,6,7,8,3,2,1,55,66,78,88
>awk '{ for (i=1; i<=5; ++i) sum[i] += $i; if (i > max) max=i } END { s=""; for (i=1; i<=max; i++) { printf "%s%s", s, sum[i]; s=OFS; } printf "\n" }' a.txt
0 0 0 0 0

it not adding the coloums
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed or awk to convert text files with recurring headings to rows and colum

I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How... (5 Replies)
Discussion started by: Bjoeboo
5 Replies

2. Shell Programming and Scripting

find lines have 2nd colum value greater than 40

i have a file a.txt 12345,20 34567,10 23123,50 123456,45 how to find lines which hav 2nd entry greater than 40 o/p 23123,50 123456,45 pls help to get o/p (5 Replies)
Discussion started by: devesh123
5 Replies

3. Shell Programming and Scripting

sed command to delete points in a certain colum

Dear Unix users, I have a (I think simple) question; I have a file (out.dat) like below, the file contains some line which include 'LOS' string. . LOS 46.5360 91.0220 200708.2515.4900. 5400 64 1100010 . . I would like to delete the points in 4th... (4 Replies)
Discussion started by: mgunduz
4 Replies

4. UNIX for Dummies Questions & Answers

joining files with different rows and colum

Hi all, I have two files: file one (9 rows, 3 columns): A 1 x1 B 2 f1 C 3 f3 D 4 u5 E 5 l9 F 6 h6 G 7 g4 H 8 r4 I 9 s2 file two (4 rows, 1 column): A B (2 Replies)
Discussion started by: anjas
2 Replies

5. Linux

Doubt on vmstat swpd colum

Dear Gurus, When i ran vmstat, i am getting swpd value,but si, and so beneath the swap is o, My doubt what is the difference between these values,i,e swpd and si and so OS is OEL 5.5 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache... (2 Replies)
Discussion started by: dave234
2 Replies

6. Shell Programming and Scripting

Sorting based on a particular colum

Hi, I want a flat file(pipe delimited) to be sorted based on 2nd column only. Below is input file to be sorted. AVERS|K50034|A|Y|N|N|Y|Y|Y|||N|N AVERS|K50035|A|Y|N|N|Y|Y|Y|||N|N... (11 Replies)
Discussion started by: Nikhath
11 Replies

7. Shell Programming and Scripting

Script by row colum

Hi All, how can output file1 to file2 by colum, e.g. $cat file1 1 2 3 $cat file2 aaa bbb ccc ddd eee fff ggg hhh iii then i need new file1 (4 Replies)
Discussion started by: aav1307
4 Replies

8. Shell Programming and Scripting

Colum number where value is >0

Hi All I want to findout coloum number where value is >0 from below string Can we do using awk or any command ? Thanks in advance ... (7 Replies)
Discussion started by: aaysa123
7 Replies

9. Shell Programming and Scripting

awk to extract multiple values from file and add two additional fields

In the attached file I am trying to use awk to extract multiple values and create the tab-delimited desired output. In the output R_Index is a the sequential # and Pre_Enrichment is defaulted to .. I can extract from the values to the side of the keywords, but most are above and I can not... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. Shell Programming and Scripting

Vlookup using awk without exact match for two colum input

Source file 1 335 R1-snapfound 0098F RDFType:R1 R2-Dev R2-snapfound ,010C0 RemoteSymmetrixID:345 335 R1-snapfound 00990 RDFType:R1 R2-Dev R2-snapfound ,010C1 RemoteSymmetrixID:345 335 R1-snapfound 009C0 RDFType:R1 R2-Dev R2-snapfound ,009C1 RemoteSymmetrixID:345 335 R1-snapfound 009C1... (5 Replies)
Discussion started by: ranjancom2000
5 Replies
INNDF(8)						      System Manager's Manual							  INNDF(8)

NAME
inndf - Replacement for 'df | awk' in innwatch.ctl SYNOPSIS
inndf [ -i ] filesystem(s) | [ -n ] [ -o ] DESCRIPTION
Inndf is a replacement for 'df | awk' in innwatch.ctl(5) or used in innstat(8). Inndf reports free Kilobytes (not disk blocks) or free inodes. Kilobytes in this case means 1024 bytes. If arguments are multiply specified, the output includes multiple lines which shows each specified argument and the value. This is used by innstat(8). Inndf doesn't sync, forks less, is less complicated, etc. If <enableoverview in inn.conf> is set to ``true'' and other overview settings are already done, inndf can also show the usage of overview space or the number of stored data. OPTIONS
-i If the ``-i'' flag is used, then the number of free inodes are reported instead of the number of free Kilobytes. -n If the ``-n'' flag is used, then total number of stored overview data is reported. The number counts different data even if article is crossposted. -o If the ``-o'' flag is used, then overview space usage are reported as percentage. ``-o'' cannot be always available. This can be available for ``buffindexed'' ovmethod currently. HISTORY
Inndf was written by Ian Dickinson <idickins@fore.com>. The initial manual page was written by Swa Frantzen <Swa.Frantzen@Belgium.EU.net>. Thanks also to the following folks for ports, patches and comments: Mahesh Ramachandran <rr@eel.ufl.edu>, Chuck Swiger <chuck@its.com>, Sang-yong Suh <sysuh@kigam.re.kr>, Brad Dickey <bdickey@haverford.edu>, Taso N. Devetzis <devetzis@snet.net>, Wei-Yeh Lee <weiyeh@colum- bia.edu>, Jeff Garzik <jeff.garzik@spinne.com>, and to all the other folks I met and worked with during my 10 years as a newsadmin. SEE ALSO
innwatch.ctl(5). INNDF(8)
All times are GMT -4. The time now is 06:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy