Sponsored Content
Top Forums UNIX for Dummies Questions & Answers [Solved] Using awk to obtain minimum of each column (ignoring zeros) Post 302570180 by kasan0 on Wednesday 2nd of November 2011 02:35:32 PM
Old 11-02-2011
Computer

Thanks very much. That works perfectly!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

truncating leading zeros of a column in a file

Hi I have a file in which I have 5 columns which are delimited by “|” as shown ABC|12|YAK|METRIC|000000019.5 XYZ|10|ABX|META|000000002.5 Now my requirement is to take the last column trim the leading zero's for that column values and write back to the same file in the same... (7 Replies)
Discussion started by: nvuradi
7 Replies

2. Shell Programming and Scripting

C shell--take the minimum of a column

I have a data file with two columns, for the second column I want to find the minimum, and subtract this minimum from each value in the second column, how to realize this using C shell For example, I have 1 -2.4 2 -4.8 3 7.9 I wanna output 1 2.4 2 0 3 12.7 Thanks! (4 Replies)
Discussion started by: rockytodd
4 Replies

3. Shell Programming and Scripting

Removing leading zeros for a decimal column

removing leading zeros for a decimal column in a file which has string & decimal values ,,,,,6630140,XXXXXXXXXXXXXXX, 0020.00,USA ,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 0010.00,USA ,,,,,6630150,XXXXXXXXXXXXXXX(xyz), 1300.00,USA My file contains 9 columns. Out 9 columns, 8th column contains the... (9 Replies)
Discussion started by: marpadga18
9 Replies

4. UNIX for Dummies Questions & Answers

Getting the minimum of each column in a file

Hi, I have a file like: 0.000000 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 124.085533 33.097845 33.363764 0.000000 266.483441 262.519130 266.380993 274.989622 289.594799 309.523518 336.124848 372.386124 413.522043 429.984825 421.621810... (6 Replies)
Discussion started by: cosmologist
6 Replies

5. Shell Programming and Scripting

Fill missing numbers in second column with zeros

Hi All, I have 100 files with names like this: 1.dat, 2.dat, 3.dat until 100.dat. My dat files look like this: 42323 0 438939 1 434 0 0.9383 3434 120.23 3 234 As you can see in the second column, some numbers are missing. I want to fill those missing places with 0's in all... (3 Replies)
Discussion started by: shoaibjameel123
3 Replies

6. Shell Programming and Scripting

[Solved] Script is ignoring  

Experts, I am finding the split up of the Servers which uses the netstat on a specific port. netstat -a | grep -w 9071 |grep ESTABLISHED | awk '{print $5}' | cut -d'.' -f1 | sort -n | uniq -c 1 ser7b 1 ser7c 2 ser7d 2 ser7e 1 ser7f 1 ser7h 1 ser7i 1 ser8bI am... (5 Replies)
Discussion started by: sathyaonnuix
5 Replies

7. Shell Programming and Scripting

[Solved] awk Column difference

Hi, I've got what is probably quite an easy little (presumably) awk problem that I just can't seem to work out (mental block...I've already spent ages getting the data into this format!). I want to work out the difference between rows for certain columns. for example: 1359142876 RED 14... (3 Replies)
Discussion started by: chrissycc
3 Replies

8. Shell Programming and Scripting

awk to print column number while ignoring alpha characters

I have the following script that will print column 4 ("25") when column 1 contains "123". However, I need to ignore the alpha characters that are contained in the input file. If I were to ignore the characters my output would be column 3. What is the best way to print my column of interest... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

9. Shell Programming and Scripting

awk to find maximum and minimum from column and store in other column

Need your support for below. Please help to get required output If column 5 is INV then only consider column1 and take out duplicates/identical rows/values from column1 and then put minimum value of column6 in column7 and put maximum value in column 8 and then need to do subtract values of... (7 Replies)
Discussion started by: as7951
7 Replies

10. Programming

Find the minimum value of the column with respect to other column

Hi All, I would like get the minimum value in the certain column with respect to other column. For example, I have a text file like this. ATOM 1 QSS SPH S 0 -2.790 -1.180 -2.282 2.28 2.28 ATOM 1 QSS SPH S 1 -2.915 -1.024 -2.032 2.31 2.31 ATOM 1 ... (4 Replies)
Discussion started by: bala06
4 Replies
Module::Starter::Smart(3pm)				User Contributed Perl Documentation			       Module::Starter::Smart(3pm)

NAME
Module::Starter::Smart - A Module::Starter plugin for adding new modules into an existing distribution VERSION
version 0.0.4 SYNOPSIS
use Module::Starter qw/Module::Starter::Smart/; Module::Starter->create_distro(%args); # or in ~/.module-starter/config plugin: Module::Starter::Smart # create a new distribution named 'Foo-Bar' $ module-starter --module=Foo::Bar # ... then add a new module $ module-starter --module=Foo::Bar::Me --distro=Foo-Bar DESCRIPTION
Module::Starter::Smart is a simple helper plugin for Module::Starter. It subclasses Module::Starter::Simple and provides its own implementatoin for several file creation subroutines, such as "create_distro", "create_modules", "create_t", and so on. These new implementations were designed to work with existing distributions. When invoked, the plugin checks if the distribution is already created. If so, the plugin would bypass "create_basedir") and go ahead pull in all the existing modules and test files; these information would be used later in the corresponding file creation subroutines for skipping already-created files. UPDATE: This plugin only covers the simplest use cases. For advanced usage, check out Module::Starter::AddModule. Example Say you have an existing distro, Goof-Ball, and you want to add a new module, Goof::Troop. % ls -R Goof-Ball Build.PL Changes MANIFEST README lib/ t/ Goof-Ball/lib: Goof/ Goof-Ball/lib/Goof: Ball.pm Goof-Ball/t: 00.load.t perlcritic.t pod-coverage.t pod.t Go to the directory containing your existing distribution and run module-starter, giving it the names of the existing distribution and the new module: % module-starter --distro=Goof-Ball --module=Goof::Troop Created starter directories and files % ls -R Goof-Ball Build.PL Changes MANIFEST README lib/ t/ Goof-Ball/lib: Goof/ Goof-Ball/lib/Goof: Ball.pm Troop.pm Goof-Ball/t: 00.load.t perlcritic.t pod-coverage.t pod.t Troop.pm has been added to Goof-Ball/lib/Goof. INTERFACE
No public methods. The module works by subclassing Module::Starter::Simple and rewiring its internal behaviors. DEPENDENCIES
Module::Starter::Smart subclasses Module::Starter::Simple. INCOMPATIBILITIES
The plugin works perfectly with other template plugins, i.e. Module::Starter::PBP (I started using it to develop this module) BUGS AND LIMITATIONS
Please report any bugs or feature requests to "bug-module-starter-smart@rt.cpan.org", or through the web interface at <http://rt.cpan.org>. ACKNOWLEDGEMENT
Special thanks to David Messina, who kindly contributes the example. AUTHOR
Ruey-Cheng Chen "<rueycheng@gmail.com>" LICENCE AND COPYRIGHT
Copyright (c) 2006, 2012 Ruey-Cheng Chen "<rueycheng@gmail.com>". All rights reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic. DISCLAIMER OF WARRANTY
BECAUSE THIS SOFTWARE IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE SOFTWARE, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE SOFTWARE "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE IS WITH YOU. SHOULD THE SOFTWARE PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR, OR CORRECTION. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE SOFTWARE AS PERMITTED BY THE ABOVE LICENCE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE SOFTWARE TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. perl v5.14.2 2012-03-29 Module::Starter::Smart(3pm)
All times are GMT -4. The time now is 01:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy