Sponsored Content
Full Discussion: Help with awk
Top Forums Shell Programming and Scripting Help with awk Post 302290396 by zainravi on Monday 23rd of February 2009 06:33:25 AM
Old 02-23-2009
Help with awk

I have a unix file whose outputis something like
Code:


 ImportType
        



                                                   Active CurrentDate Failed
        Status                                             LastCompleted
 --------------------------------------------------
        -----------------------------------------------------------------------
        -----------------------------------------------------------------------
        -----------------------------------------------------------------------
        ------------------------------------------ ------ ----------- ------
        -------------------------------------------------- -------------------
 Area
        \\outwtq13\wndt\epxompbe\gjmft\Areas.ebu


                                                        1 20090224         0
        Import Complete                                    2009-02-23 04:26:00
 Product
        \\outwtq13\wndt\epxompbe\gjmft\items.ebu


                                                        1 20090224         0
        Import Complete                                    2009-02-23 04:26:00
 Store
        \\outwtq13\wndt\epxompbe\gjmft\Stores.ebu


                                                        1 20090224         0
        Import Complete                                    2009-02-23 04:28:00
 Region
        \\outwtq13\wndt\epxompbe\gjmft\Regions.ebu


                                                        1 20090224         0
        Import Complete                                    2009-02-23 04:28:00
 LineList
        \\outwtq13\wndt\epxompbe\gjmft\linelist.ebu


                                                        1 20090223         0
        Import Complete                                    2009-02-23 06:25:00

(5 rows affected)

I need to write an awk program to ensure the output looks like
Code:
ImportType Import File									Active 		CurrentDate FailedStatus LastCompleted
 Area  	    \\outwtq13\wndt\epxompbe\gjmft\items.ebu    1 			20090224	0			 2009-02-23 04:26:00

Could you please help me. I hope there is sufficient information here.

Last edited by otheus; 02-23-2009 at 07:39 AM.. Reason: code tags added, spellings fixed
 

10 More Discussions You Might Find Interesting

1. 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

2. Shell Programming and Scripting

scripting/awk help : awk sum output is not comming in regular format. Pls advise.

Hi Experts, I am adding a column of numbers with awk , however not getting correct output: # awk '{sum+=$1} END {print sum}' datafile 2.15291e+06 How can I getthe output like : 2152910 Thank you.. # awk '{sum+=$1} END {print sum}' datafile 2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies

3. Shell Programming and Scripting

awk: assign variable with -v didn't work in awk filter

I want to filter 2nd column = 2 using awk $ cat t 1 2 2 4 $ VAR=2 #variable worked in print $ cat t | awk -v ID=$VAR ' { print ID}' 2 2 # but variable didn't work in awk filter $ cat t | awk -v ID=$VAR '$2~/ID/ { print $0}' (2 Replies)
Discussion started by: honglus
2 Replies

4. Shell Programming and Scripting

Problem with awk awk: program limit exceeded: sprintf buffer size=1020

Hi I have many problems with a script. I have a script that formats a text file but always prints the same error when i try to execute it The code is that: { if (NF==17){ print $0 }else{ fields=NF; all=$0; while... (2 Replies)
Discussion started by: fate
2 Replies

5. Shell Programming and Scripting

Comparison and editing of files using awk.(And also a possible bug in awk for loop?)

I have two files which I would like to compare and then manipulate in a way. File1: pictures.txt 1.1 1.3 dance.txt 1.2 1.4 treehouse.txt 1.3 1.5 File2: pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244 dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2... (1 Reply)
Discussion started by: linuxkid
1 Replies

6. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Discussion started by: anandek
10 Replies

7. Shell Programming and Scripting

HELP with AWK one-liner. Need to employ an If condition inside AWK to check for array variable ?

Hello experts, I'm stuck with this script for three days now. Here's what i need. I need to split a large delimited (,) file into 2 files based on the value present in the last field. Samp: Something.csv bca,adc,asdf,123,12C bca,adc,asdf,123,13C def,adc,asdf,123,12A I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies

8. Shell Programming and Scripting

Passing awk variable argument to a script which is being called inside awk

consider the script below sh /opt/hqe/hqapi1-client-5.0.0/bin/hqapi.sh alert list --host=localhost --port=7443 --user=hqadmin --password=hqadmin --secure=true >/tmp/alerts.xml awk -F'' '{for(i=1;i<=NF;i++){ if($i=="Alert id") { if(id!="") if(dt!=""){ cmd="sh someScript.sh... (2 Replies)
Discussion started by: vivek d r
2 Replies

9. Shell Programming and Scripting

Pass awk field to a command line executed within awk

Hi, I am trying to pass awk field to a command line executed within awk (need to convert a timestamp into formatted date). All my attempts failed this far. Here's an example. It works fine with timestamp hard-codded into the command echo "1381653229 something" |awk 'BEGIN{cmd="date -d... (4 Replies)
Discussion started by: tuxer
4 Replies

10. Shell Programming and Scripting

awk output yields error: awk:can't open job_name (Autosys)

Good evening, Im newbie at unix specially with awk From an scheduler program called Autosys i want to extract some data reading an inputfile that comprises jobs names, then formating the output to columns for example 1. This is the inputfile: $ more MapaRep.txt ds_extra_nikira_usuarios... (18 Replies)
Discussion started by: alexcol
18 Replies
Import::Into(3) 					User Contributed Perl Documentation					   Import::Into(3)

NAME
Import::Into - import packages into other packages SYNOPSIS
package My::MultiExporter; use Import::Into; use Thing1 (); use Thing2 (); # simple sub import { Thing1->import::into(scalar caller); } # multiple sub import { my $target = caller; Thing1->import::into($target); Thing2->import::into($target, qw(import arguments)); } # by level sub import { Thing1->import::into(1); } # with exporter use base qw(Exporter); sub import { shift->export_to_level(1); Thing1->import::into(1); } # no My::MultiExporter == no Thing1 sub unimport { Thing1->unimport::out_of(scalar caller); } People wanting to re-export your module should also be using Import::Into. Any exporter or pragma will work seamlessly. Note: You do not need to make any changes to Thing1 to be able to call "import::into" on it. This is a global method, and is callable on any package (and in fact on any object as well, although it's rarer that you'd want to do that). DESCRIPTION
Writing exporters is a pain. Some use Exporter, some use Sub::Exporter, some use Moose::Exporter, some use Exporter::Declare ... and some things are pragmas. Exporting on someone else's behalf is harder. The exporters don't provide a consistent API for this, and pragmas need to have their import method called directly, since they effect the current unit of compilation. "Import::Into" provides global methods to make this painless. METHODS
$package->import::into( $target, @arguments ); A global method, callable on any package. Imports the given package into $target. @arguments are passed along to the package's import method. $target can be an package name to export to, an integer for the caller level to export to, or a hashref with the following options: package The target package to export to. filename The apparent filename to export to. Some exporting modules, such as autodie or strictures, care about the filename they are being imported to. line The apparent line number to export to. To be combined with the "filename" option. level The caller level to export to. This will automatically populate the "package", "filename", and "line" options, making it the easiest most constent option. version A version number to check for the module. The equivalent of specifying the version number on a "use" line. $package->unimport::out_of( $target, @arguments ); Equivalent to "import::into", but dispatches to $package's "unimport" method instead of "import". WHY USE THIS MODULE
The APIs for exporting modules aren't consistent. Exporter subclasses provide export_to_level, but if they overrode their import method all bets are off. Sub::Exporter provides an into parameter but figuring out something used it isn't trivial. Pragmas need to have their "import" method called directly since they affect the current unit of compilation. It's ... annoying. However, there is an approach that actually works for all of these types. eval "package $target; use $thing;" will work for anything checking caller, which is everything except pragmas. But it doesn't work for pragmas - pragmas need: $thing->import; because they're designed to affect the code currently being compiled - so within an eval, that's the scope of the eval itself, not the module that just "use"d you - so sub import { eval "use strict;" } doesn't do what you wanted, but sub import { strict->import; } will apply strict to the calling file correctly. Of course, now you have two new problems - first, that you still need to know if something's a pragma, and second that you can't use either of these approaches alone on something like Moose or Moo that's both an exporter and a pragma. So, a solution for that is: my $sub = eval "package $target; sub { shift->import(@_) }"; $sub->($thing, @import_args); which means that import is called from the right place for pragmas to take effect, and from the right package for caller checking to work - and so behaves correctly for all types of exporter, for pragmas, and for hybrids. Additionally, some import routines check the filename they are being imported to. This can be dealt with by generating a #line directive in the eval, which will change what "caller" reports for the filename when called in the importer. The filename and line number to use in the directive then need to be fetched using "caller": my ($target, $file, $line) = caller(1); my $sub = eval qq{ package $target; #line $line "$file" sub { shift->import(@_) } }; $sub->($thing, @import_args); And you need to switch between these implementations depending on if you are targetting a specific package, or something in your call stack. Remembering all this, however, is excessively irritating. So I wrote a module so I didn't have to anymore. Loading Import::Into creates a global method "import::into" which you can call on any package to import it into another package. So now you can simply write: use Import::Into; $thing->import::into($target, @import_args); This works because of how perl resolves method calls - a call to a simple method name is resolved against the package of the class or object, so $thing->method_name(@args); is roughly equivalent to: my $code_ref = $thing->can('method_name'); $code_ref->($thing, @args); while if a "::" is found, the lookup is made relative to the package name (i.e. everything before the last "::") so $thing->Package::Name::method_name(@args); is roughly equivalent to: my $code_ref = Package::Name->can('method_name'); $code_ref->($thing, @args); So since Import::Into defines a method "into" in package "import" the syntax reliably calls that. For more craziness of this order, have a look at the article I wrote at <http://shadow.cat/blog/matt-s-trout/madness-with-methods> which covers coderef abuse and the "${...}" syntax. Final note: You do still need to ensure that you already loaded $thing - if you're receiving this from a parameter, I recommend using Module::Runtime: use Import::Into; use Module::Runtime qw(use_module); use_module($thing)->import::into($target, @import_args); And that's it. ACKNOWLEDGEMENTS
Thanks to Getty for asking "how can I get "use strict; use warnings;" turned on for all consumers of my code?" and then "why is this not a module?!". AUTHOR
mst - Matt S. Trout (cpan:MSTROUT) <mst@shadowcat.co.uk> CONTRIBUTORS
haarg - Graham Knop (cpan:HAARG) <haarg@haarg.org> COPYRIGHT
Copyright (c) 2012 the Import::Into "AUTHOR" and "CONTRIBUTORS" as listed above. LICENSE
This library is free software and may be distributed under the same terms as perl itself. perl v5.18.2 2013-12-10 Import::Into(3)
All times are GMT -4. The time now is 05:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy