Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Script to do column to row in awk Post 303043579 by vgersh99 on Friday 31st of January 2020 09:42:47 PM
Old 01-31-2020
Any ideas/hints you can think of?
How about looking into FNR % 3 for starters?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get value of last row and 6 column from awk

I want to get value of last row and 6 column from awk. Below is the format of my file. And RED one is my desired value. Actaully this stats usally update after every 1 hour so i want that every time i run the script i get the latest value. Ending time - 01:00:58 HOURLY CALL ATTEMPTS... (4 Replies)
Discussion started by: wakhan
4 Replies

2. UNIX for Dummies Questions & Answers

awk question row into column

I have a csv file: test1.csv with 26 columns Sample: Data collected Comp1,,,,,,,,,,,,,,,,,,,,,,,,,Average Number of Arrivals with non Zero,0,0,0,0,0,0,0,0,0,...,0 %Utilization,0.1,0.23,0.14,...,0.36 Data collected Comp2,,,,,,,,,,,,,,,,,,,,,,,,,Average Number of Arrivals with non... (2 Replies)
Discussion started by: calitiggr
2 Replies

3. Shell Programming and Scripting

AWK Script - Print a column - within a Row Range

Hi, Please read the whole thread. I have been working on this script below. It works fine, feel free to copy and test with the INPUT File below as well. example: PACKET DATA PROTOCOL CONTEXT DATA APNID PDPADD EQOSID VPAA PDPCH PDPTY PDPID 10 ... (6 Replies)
Discussion started by: panapty
6 Replies

4. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

5. Shell Programming and Scripting

awk transpose row into 2 field column

Need to transpose every 2 fields of a row into a single 2 field column. input 4 135 114 76 217 30 346 110 5 185 115 45 218 85 347 125 6 85 116 130 220 65 352 95 11 30 117 55 221 42 355 75 16 72 118 55 224 37 357 430 17 30 119 55 225 40 358 62 21 52 120 65 232 480 360 180 ....... (8 Replies)
Discussion started by: sdf
8 Replies

6. UNIX for Dummies Questions & Answers

append column and row header to a file in awk script.

Hi! Is there a way to append column and row header to a file in awk script. For example if I have Jane F 39 manager Carlos M 40 system administrator Sam F 20 programmer and I want it to be # name gend age occup 1 Jane F 39 manager 2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies

7. Shell Programming and Scripting

awk - script help: column to row format of data allignment?

Experts Good day, I have the following data, file1 BRAAGRP1 A2X B2X C2X D2X BRBGRP12 A3X B3X Z10 D09 BRC1GRP2 LO01 (4 Replies)
Discussion started by: rveri
4 Replies

8. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

9. Shell Programming and Scripting

Transpose column to row - awk

Hi there, I have a small csv file example below: source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512 I want to transpose columns to rows starting at the second... (3 Replies)
Discussion started by: theflamingmoe
3 Replies

10. Shell Programming and Scripting

awk script row to column

Hi.. I have data : Report testing1 20180419 08:00 Report testing2 20180419 07:35 Report testing 20180419 08:01 Source = data1 Report testing4 20180419 08:05 Source = data1 Report testing5 20180419 08:10 Source = data2 Report testing6 20180419 08:01 Report testing7 20180419 08:19... (4 Replies)
Discussion started by: buncit8
4 Replies
autodie::hints(3)					User Contributed Perl Documentation					 autodie::hints(3)

NAME
autodie::hints - Provide hints about user subroutines to autodie SYNOPSIS
package Your::Module; our %DOES = ( 'autodie::hints::provider' => 1 ); sub AUTODIE_HINTS { return { foo => { scalar => HINTS, list => SOME_HINTS }, bar => { scalar => HINTS, list => MORE_HINTS }, } } # Later, in your main program... use Your::Module qw(foo bar); use autodie qw(:default foo bar); foo(); # succeeds or dies based on scalar hints # Alternatively, hints can be set on subroutines we've # imported. use autodie::hints; use Some::Module qw(think_positive); BEGIN { autodie::hints->set_hints_for( &think_positive, { fail => sub { $_[0] <= 0 } } ) } use autodie qw(think_positive); think_positive(...); # Returns positive or dies. DESCRIPTION
Introduction The autodie pragma is very smart when it comes to working with Perl's built-in functions. The behaviour for these functions are fixed, and "autodie" knows exactly how they try to signal failure. But what about user-defined subroutines from modules? If you use "autodie" on a user-defined subroutine then it assumes the following behaviour to demonstrate failure: o A false value, in scalar context o An empty list, in list context o A list containing a single undef, in list context All other return values (including the list of the single zero, and the list containing a single empty string) are considered successful. However, real-world code isn't always that easy. Perhaps the code you're working with returns a string containing the word "FAIL" upon failure, or a two element list containing "(undef, "human error message")". To make autodie work with these sorts of subroutines, we have the hinting interface. The hinting interface allows hints to be provided to "autodie" on how it should detect failure from user-defined subroutines. While these can be provided by the end-user of "autodie", they are ideally written into the module itself, or into a helper module or sub-class of "autodie" itself. What are hints? A hint is a subroutine or value that is checked against the return value of an autodying subroutine. If the match returns true, "autodie" considers the subroutine to have failed. If the hint provided is a subroutine, then "autodie" will pass the complete return value to that subroutine. If the hint is any other value, then "autodie" will smart-match against the value provided. In Perl 5.8.x there is no smart-match operator, and as such only subroutine hints are supported in these versions. Hints can be provided for both scalar and list contexts. Note that an autodying subroutine will never see a void context, as "autodie" always needs to capture the return value for examination. Autodying subroutines called in void context act as if they're called in a scalar context, but their return value is discarded after it has been checked. Example hints Hints may consist of scalars, array references, regular expressions and subroutine references. You can specify different hints for how failure should be identified in scalar and list contexts. These examples apply for use in the "AUTODIE_HINTS" subroutine and when calling "autodie::hints-"set_hints_for()>. The most common context-specific hints are: # Scalar failures always return undef: { scalar => undef } # Scalar failures return any false value [default expectation]: { scalar => sub { ! $_[0] } } # Scalar failures always return zero explicitly: { scalar => '0' } # List failures always return an empty list: { list => [] } # List failures return () or (undef) [default expectation]: { list => sub { ! @_ || @_ == 1 && !defined $_[0] } } # List failures return () or a single false value: { list => sub { ! @_ || @_ == 1 && !$_[0] } } # List failures return (undef, "some string") { list => sub { @_ == 2 && !defined $_[0] } } # Unsuccessful foo() returns 'FAIL' or '_FAIL' in scalar context, # returns (-1) in list context... autodie::hints->set_hints_for( &foo, { scalar => qr/^ _? FAIL $/xms, list => [-1], } ); # Unsuccessful foo() returns 0 in all contexts... autodie::hints->set_hints_for( &foo, { scalar => 0, list => [0], } ); This "in all contexts" construction is very common, and can be abbreviated, using the 'fail' key. This sets both the "scalar" and "list" hints to the same value: # Unsuccessful foo() returns 0 in all contexts... autodie::hints->set_hints_for( &foo, { fail => sub { @_ == 1 and defined $_[0] and $_[0] == 0 } } ); # Unsuccessful think_positive() returns negative number on failure... autodie::hints->set_hints_for( &think_positive, { fail => sub { $_[0] < 0 } } ); # Unsuccessful my_system() returns non-zero on failure... autodie::hints->set_hints_for( &my_system, { fail => sub { $_[0] != 0 } } ); Manually setting hints from within your program If you are using a module which returns something special on failure, then you can manually create hints for each of the desired subroutines. Once the hints are specified, they are available for all files and modules loaded thereafter, thus you can move this work into a module and it will still work. use Some::Module qw(foo bar); use autodie::hints; autodie::hints->set_hints_for( &foo, { scalar => SCALAR_HINT, list => LIST_HINT, } ); autodie::hints->set_hints_for( &bar, { fail => SOME_HINT, } ); It is possible to pass either a subroutine reference (recommended) or a fully qualified subroutine name as the first argument. This means you can set hints on modules that might get loaded: use autodie::hints; autodie::hints->set_hints_for( 'Some::Module:bar', { fail => SCALAR_HINT, } ); This technique is most useful when you have a project that uses a lot of third-party modules. You can define all your possible hints in one-place. This can even be in a sub-class of autodie. For example: package my::autodie; use parent qw(autodie); use autodie::hints; autodie::hints->set_hints_for(...); 1; You can now "use my::autodie", which will work just like the standard "autodie", but is now aware of any hints that you've set. Adding hints to your module "autodie" provides a passive interface to allow you to declare hints for your module. These hints will be found and used by "autodie" if it is loaded, but otherwise have no effect (or dependencies) without autodie. To set these, your module needs to declare that it does the "autodie::hints::provider" role. This can be done by writing your own "DOES" method, using a system such as "Class::DOES" to handle the heavy-lifting for you, or declaring a %DOES package variable with a "autodie::hints::provider" key and a corresponding true value. Note that checking for a %DOES hash is an "autodie"-only short-cut. Other modules do not use this mechanism for checking roles, although you can use the "Class::DOES" module from the CPAN to allow it. In addition, you must define a "AUTODIE_HINTS" subroutine that returns a hash-reference containing the hints for your subroutines: package Your::Module; # We can use the Class::DOES from the CPAN to declare adherence # to a role. use Class::DOES 'autodie::hints::provider' => 1; # Alternatively, we can declare the role in %DOES. Note that # this is an autodie specific optimisation, although Class::DOES # can be used to promote this to a true role declaration. our %DOES = ( 'autodie::hints::provider' => 1 ); # Finally, we must define the hints themselves. sub AUTODIE_HINTS { return { foo => { scalar => HINTS, list => SOME_HINTS }, bar => { scalar => HINTS, list => MORE_HINTS }, baz => { fail => HINTS }, } } This allows your code to set hints without relying on "autodie" and "autodie::hints" being loaded, or even installed. In this way your code can do the right thing when "autodie" is installed, but does not need to depend upon it to function. Insisting on hints When a user-defined subroutine is wrapped by "autodie", it will use hints if they are available, and otherwise reverts to the default behaviour described in the introduction of this document. This can be problematic if we expect a hint to exist, but (for whatever reason) it has not been loaded. We can ask autodie to insist that a hint be used by prefixing an exclamation mark to the start of the subroutine name. A lone exclamation mark indicates that all subroutines after it must have hints declared. # foo() and bar() must have their hints defined use autodie qw( !foo !bar baz ); # Everything must have hints (recommended). use autodie qw( ! foo bar baz ); # bar() and baz() must have their hints defined use autodie qw( foo ! bar baz ); # Enable autodie for all of Perl's supported built-ins, # as well as for foo(), bar() and baz(). Everything must # have hints. use autodie qw( ! :all foo bar baz ); If hints are not available for the specified subroutines, this will cause a compile-time error. Insisting on hints for Perl's built-in functions (eg, "open" and "close") is always successful. Insisting on hints is strongly recommended. Diagnostics Attempts to set_hints_for unidentifiable subroutine You've called "autodie::hints->set_hints_for()" using a subroutine reference, but that reference could not be resolved back to a subroutine name. It may be an anonymous subroutine (which can't be made autodying), or may lack a name for other reasons. If you receive this error with a subroutine that has a real name, then you may have found a bug in autodie. See "BUGS" in autodie for how to report this. fail hints cannot be provided with either scalar or list hints for %s When defining hints, you can either supply both "list" and "scalar" keywords, or you can provide a single "fail" keyword. You can't mix and match them. %s hint missing for %s You've provided either a "scalar" hint without supplying a "list" hint, or vice-versa. You must supply both "scalar" and "list" hints, or a single "fail" hint. ACKNOWLEDGEMENTS
o Dr Damian Conway for suggesting the hinting interface and providing the example usage. o Jacinta Richardson for translating much of my ideas into this documentation. AUTHOR
Copyright 2009, Paul Fenwick <pjf@perltraining.com.au> LICENSE
This module is free software. You may distribute it under the same terms as Perl itself. SEE ALSO
autodie, Class::DOES perl v5.16.3 2013-02-22 autodie::hints(3)
All times are GMT -4. The time now is 06:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy