Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Using awk on multiple files in a directory
Top Forums Shell Programming and Scripting Using awk on multiple files in a directory Post 302838009 by SkySmart on Sunday 28th of July 2013 02:28:19 PM
Old 07-28-2013
Quote:
Originally Posted by RudiC
Why don't you gunzip all files upfront and then apply the awk script to the entire directory?
actually that's the least of my problems now. i believe i'll be able to figure that out at the end. but the only other question i have is, lets say the first time i run this command, i get and output similar to this:

Code:
first run:
/data/projects/file01,300lines,130lines matching 'Customer.*Processed'

(note, this is just one file out of many that would be in the output.)

now, the above output is saved to a file called /tmp/results.txt
the second time i run this command, say 5 minutes later, there'd be a line in the output similar to:

Code:
second run:
/data/projects/file01,410lines,139lines matching 'Customer.*Processed'

now, i dont want to search through each file again. i want to begin from the point where the last scan left off.

in the first run, there were 300 lines in the file named '/data/projects/file01. I want it so that, the next time i run the script, awk can begin from line 301 to the end of the file. and i want to have this happen for all the files it finds in the directory. this way, only the first run will be slow. all runs after that will be fast.

here's my attempt to modify your code:
Code:
lastlinenumber=$(awk -F"," '{print $2}' /tmp/results.txt | sed 's/lines//g')

awk    -v LLNUM=${lastlinenumber}  'FNR == 1               {if (NR > 1) {print fn, "text1", fnr, "text2", nl}
                                 fn=FILENAME; fnr = 1; nl = 0}
                                {fnr = FNR}
         /customer.*processed/  && NR>LLNUM {nl++}
         END                    {print fn, "text1", fnr, "text2", nl}
        ' file?

if while comparing the most recent list of files in the latest scan, it finds a file that didn't exist in the previous scan, it'll scan that file in its entirety because it would be considered new.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ftp multiple files from same directory

Hi there Gurus, I have the following ftp script: $ more ftp_dump_arch4.sh #! /usr/bin/ksh # Constant variables HOST='xx.xx.xx.xx' USER='user' PASSWD='password' dir='/export/file' ftp_log='/tmp' ftp -n $HOST > $ftp_log/ftp.log << END user $USER $PASSWD verbose lcd $dir bin (3 Replies)
Discussion started by: lweegp
3 Replies

2. Shell Programming and Scripting

Multiple search string in multiple files using awk

Hi, filenames: contains name of list of files to search in. placelist contains the names of places to be searched in all files in "filenames" for i in $(<filenames) do egrep -f placelist $i if ] then echo $i fi done >> outputfile Output i am getting: (0 Replies)
Discussion started by: pinnacle
0 Replies

3. Shell Programming and Scripting

extract multiple cloumns from multiple files; skip rows and include filenames; awk

Hello, I am trying to write a bash shell script that does the following: 1.Finds all *.txt files within my directory of interest 2. reads each of the files (25 files) one by one (tab-delimited format and have the same data format) 3. skips the first 10 rows of the file 4. extracts and... (4 Replies)
Discussion started by: manishabh
4 Replies

4. Shell Programming and Scripting

How to Pull out multiple files from DB table and redirect all those files to a differetn directory?

Hi everyone!! I have a database table, which has file_name as one of its fields. Example: File_ID File_Name Directory Size 0001 UNO_1232 /apps/opt 234 0002 UNO_1234 /apps/opt 788 0003 UNO_1235 /apps/opt 897 0004 UNO_1236 /apps/opt 568 I have to... (3 Replies)
Discussion started by: ss3944
3 Replies

5. UNIX for Dummies Questions & Answers

best method of replacing multiple strings in multiple files - sed or awk? most simple preferred :)

Hi guys, say I have a few files in a directory (58 text files or somthing) each one contains mulitple strings that I wish to replace with other strings so in these 58 files I'm looking for say the following strings: JAM (replace with BUTTER) BREAD (replace with CRACKER) SCOOP (replace... (19 Replies)
Discussion started by: rich@ardz
19 Replies

6. UNIX for Dummies Questions & Answers

Using AWK: Extract data from multiple files and output to multiple new files

Hi, I'd like to process multiple files. For example: file1.txt file2.txt file3.txt Each file contains several lines of data. I want to extract a piece of data and output it to a new file. file1.txt ----> newfile1.txt file2.txt ----> newfile2.txt file3.txt ----> newfile3.txt Here is... (3 Replies)
Discussion started by: Liverpaul09
3 Replies

7. Shell Programming and Scripting

apply record separator to multiple files within a directory using awk

Hi, I have a bunch of records within a directory where each one has this form: (example file1) 1 2 50 90 80 90 43512 98 0909 79869 -9 7878 33222 8787 9090 89898 7878 8989 7878 6767 89 89 78676 9898 000 7878 5656 5454 5454 and i want for all of these files to be... (3 Replies)
Discussion started by: amarn
3 Replies

8. Shell Programming and Scripting

perform 3 awk commands to multiple files in multiple directories

Hi, I have a directory /home/datasets/ which contains a bunch (720) of subdirectories called hour_1/ hour_2/ etc..etc.. in each of these there is a single text file called (hour_1.txt in hour_1/ , hour_2.txt for hour_2/ etc..etc..) and i would like to do some text processing in them. Each of... (20 Replies)
Discussion started by: amarn
20 Replies

9. UNIX for Dummies Questions & Answers

Multiple files with the same name in the same directory

Hi, Is it possible to have multiple files with the same name in a same unix directory? Eg., in the path \tmp, can we have 2 files with the same name as SALES_data_20120124.TXT? I heard it is possible if the user id that is created the files are different and with some ids, a new gets... (1 Reply)
Discussion started by: Vijay81
1 Replies

10. Shell Programming and Scripting

awk, multiple files input and multiple files output

Hi! I'm new in awk and I need some help. I have a folder with a lot of files and I need that awk do something in each file and print a new file with the output. The input file name should be modified when I print the outpu files. Thanks in advance for help! :-) ciao (5 Replies)
Discussion started by: gabrysfe
5 Replies

LEARN ABOUT DEBIAN

test::regression

Test::Regression(3pm)					User Contributed Perl Documentation				     Test::Regression(3pm)

NAME

       Test::Regression - Test library that can be run in two modes; one to generate outputs and a second to compare against them

VERSION

       Version 0.05

SYNOPSIS

	 use Test::Regression;
	 ok_regression(sub {return "hello world"}, "t/out/hello_world.txt");

DESCRIPTION

       Using the various Test:: modules you can compare the output of a function against what you expect.  However if the output is complex and
       changes from version to version, maintenance of the expected output could be costly. This module allows one to use the test code to
       generate the expected output, so that if the differences with model output are expected, one can easily refresh the model output.

EXPORT

       ok_regression

FUNCTIONS

   ok_regression
       This function requires two arguments: a CODE ref and a file path.  The CODE ref is expected to return a SCALAR string which can be compared
       against previous runs.  If the TEST_REGRESSION_GEN is set to a true value, then the CODE ref is run and the output written to the file.
       Otherwise the output of the file is compared against the contents of the file.  There is a third optional argument which is the test name.

ENVIRONMENT VARIABLES

   TEST_REGRESSION_GEN
       If the TEST_REGRESSION_GEN environment file is unset or false in a perl sense, then the named output files must exist and be readable and
       the test will run normally comparing the outputs of the CODE refs against the contents of those files. If the environment variable is true
       in a perl sense, then model output files will be overwritten with the output of the CODE ref.

AUTHOR

       Nicholas Bamber, "<nicholas at periapt.co.uk>"

BUGS

       Please report any bugs or feature requests to "bug-test-regression at rt.cpan.org", or through the web interface at
       <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Test-Regression>.  I will be notified, and then you'll automatically be notified of
       progress on your bug as I make changes.

   testing of STDERR
       The testing of stderr from this module is not as thorough as I would like. Test::Builder::Tester allows turning off of stderr checking but
       not matching by regular expression. Handcrafted efforts currently fall foul of Test::Harness.  Still it is I believe adequately tested in
       terms of coverage.

SUPPORT

       You can find documentation for this module with the perldoc command.

	   perldoc Test::Regression

       You can also look for information at:

       o   RT: CPAN's request tracker

	   <http://rt.cpan.org/NoAuth/Bugs.html?Dist=Test-Regression>

       o   AnnoCPAN: Annotated CPAN documentation

	   <http://annocpan.org/dist/Test-Regression>

       o   CPAN Ratings

	   <http://cpanratings.perl.org/d/Test-Regression>

       o   Search CPAN

	   <http://search.cpan.org/dist/Test-Regression/>

ACKNOWLEDGEMENTS

       Some documentation improvements have been suggested by toolic (http://perlmonks.org/?node_id=622051).
       Thanks to Filip GraliXski for pointing out I need to test against output of zero length and providing a patch.

COPYRIGHT &; LICENSE
       Copyright 2009-10 Nicholas Bamber.

       This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as
       published by the Free Software Foundation; or the Artistic License.

       See http://dev.perl.org/licenses/ for more information.

perl v5.10.1							    2010-08-29						     Test::Regression(3pm)
All times are GMT -4. The time now is 08:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy