Search Results

Mr. Moderator,

It worked. Thanks a lot. You did it again. It prints in order now.

Thanks,
-Arv

Sorry, I do not have perl. Thanks.

---------- Post updated at 12:48 PM ---------- Previous update was at 11:13 AM ----------

Sorry, I do not have perl.

bartus11, Your code gets me good results but it prints in reverse. Here is my data again:

Fri May 13 10:29:16 2011
sd5,1.4,0.4,20.9,0.8,0.0,0.0,7.0,0,0
sd12,1.0,0.5,59.3,10.9,0.0,0.0,1.4,0,0...

awk experts,

I have in put file with time stamp followed by "," separated data. same patern continues. The output need time stamp in first columns and data total in 2nd columns.

Input file
...

:b::)Yes. Thanks.

Vgresh,

Thanks again. It worked as last night's script. The input is "," separated file.
Regards,
-Arv

Vgresh, The total columns has all zeros. Last night script has good output. Just confirm it totals the "Commands" field and we are done with this post.

Thanks,
Arv

Sorry, I may have missed something. The final output should have only two columns. First timestamp and 2nd Total. Your last night script had good output. The new one has multiple columns.

Output...

Vgersh,

Thanks a lot, it worked.
To clarify the data: The input file has first columns as timestamp, rest of the fields are number under different headre. Your awk should keep first field,...

What will this do? I have many columns with zero output. those can be deleted, if all the raw for that columns are zero.

---------- Post updated at 03:46 PM ---------- Previous update was at...

:b:vgersh99, It worked. Thanks a lot. Let me run through real data. Good JOb.

---------- Post updated at 03:38 PM ---------- Previous update was at 03:33 PM ----------

One more questions on the...

I got following error: What did I missed?

[root@esx09 ~]# ./esx09.scr
./esx09.scr: line 14: nawk: command not found
[root@esx09 ~]# more esx09.scr
nawk '
FNR==1{
...

Thanks. This works for the test file but not for the real file which has 4000 columns. and the substring "kkk" could be in any column and may be in 1000 different columns. Need an if statement in...

Sure.
Input with 4000 columns.
abc,xxkkk,eeee,eee,kkknn,sss,xxx,kkkvvv,yyy, ttt,mmm,fff..........
1,1,3,4,6,7,8,9,9,0,0,5
3,4,1,5,1,5,6,7,8,9,9,7,

Would like to print the colums with header...

awk experts,

I have a big file of 4000 columns with header. Would like to print the columns with string value of "Commands" in header. File has "," separator. This file is on ESX host with...