Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help using awk with a text file
Top Forums UNIX for Advanced & Expert Users Help using awk with a text file Post 302788931 by ziggy6 on Tuesday 2nd of April 2013 05:22:19 PM
Old 04-02-2013
Test on awk script
Well it is real close but I must be missing a quote in the awk script because it is using the literal of the month and year instead of populating with the real month and year. Did I miss a tick on the copy and paste?
933 Apr 2 17:08 100$(date +%m%y).txt
866 Apr 2 17:08 103$(date +%m%y).txt
866 Apr 2 17:08 105$(date +%m%y).txt
Code:
awk -v my="$(date "+%m%y")" '
{       out = out $0 "\n"
}
(NR % 55) == 10 {
        CN = substr($0, 1, 5)
        if(lCN != CN) {
                if(fn != "") close(fn)
                fn = sprintf("%d%s.txt", lCN = CN, my)
        }
        next
}
(NR % 55) == 0 {
        printf("%s", out) > fn
        out = ""
}
END {   if(fn != "") close(fn)
}' report10.txt

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

process text file with awk

I have a text file which represent a http packet: header1 haeder2 ..... ..... headern payload I need to count bytes in the payload. How can I get it using awk? Thanks in advance Andrea Musella (2 Replies)
Discussion started by: littleboyblu
2 Replies

2. Shell Programming and Scripting

awk to reformat a text file

I am definitely not an expert with awk, and I want to reformat a text file like the following. This is probably a very easy one for an expert out there. I would like to keep the lines in the same order, but move the heading to only be listed once above the lines. This is what the text file... (7 Replies)
Discussion started by: linux4life
7 Replies

3. Shell Programming and Scripting

search text file in file if this file contains necessary text (awk,grep)

Hello friends! Help me pls to write correct awk and grep statements for my task: I have got files with name filename.txt It has such structure: Start of file FROM: address@domen.com (12...890) abc DATE: 11/23/2009 on Std SUBJECT: any subject End of file So, I must check, if this file... (4 Replies)
Discussion started by: candyme
4 Replies

4. UNIX for Advanced & Expert Users

Help using Awk and cut with a text file

Looking for some help on using awk and cut I have a text file that has fixed information and want to write a script that will prompt the user for an account to search for and pint the output The sample line that has the key information looks like this: Statement to: ... (5 Replies)
Discussion started by: ziggy6
5 Replies

5. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies

6. Shell Programming and Scripting

Search and replace from file in awk using a 16 bit text file

Hello, Some time ago a helpful awk file was provided on the forum which I give below: NR==FNR{A=$0;next}{for(j in A){split(A,P,"=");for(i=1;i<=NF;i++){if($i==P){$i=P}}}}1 While it works beautifully on English and Latin characters i.e. within the ASCII range of 127, the moment a character beyond... (6 Replies)
Discussion started by: gimley
6 Replies

7. Shell Programming and Scripting

awk to reformat text file

Howdy. AWK beginner here. I need to reformat a text file in the following format: TTGS08-2014001 6018.00 143563.00 ... (2 Replies)
Discussion started by: c47v3770
2 Replies

8. Shell Programming and Scripting

Splitting a text file into smaller files with awk, how to create a different name for each new file

Hello, I have some large text files that look like, putrescine Mrv1583 01041713302D 6 5 0 0 0 0 999 V2000 2.0928 -0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 5.6650 0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 3.5217 ... (3 Replies)
Discussion started by: LMHmedchem
3 Replies

9. UNIX for Beginners Questions & Answers

awk to update file with partial matching line in another file and append text

In the awk below I am trying to cp and paste each matching line in f2 to $3 in f1 if $2 of f1 is in the line in f2 somewhere. There will always be a match (usually more then 1) and my actual data is much larger (several hundreds of lines) in both f1 and f2. When the line in f2 is pasted to $3 in... (4 Replies)
Discussion started by: cmccabe
4 Replies

10. Shell Programming and Scripting

Match text to lines in a file, iterate backwards until text or text substring matches, print to file

hi all, trying this using shell/bash with sed/awk/grep I have two files, one containing one column, the other containing multiple columns (comma delimited). file1.txt abc12345 def12345 ghi54321 ... file2.txt abc1,text1,texta abc,text2,textb def123,text3,textc gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies

LEARN ABOUT DEBIAN

html::formhandler::field::date

HTML::FormHandler::Field::Date(3pm)			User Contributed Perl Documentation		       HTML::FormHandler::Field::Date(3pm)

NAME

       HTML::FormHandler::Field::Date - a date field with formats

VERSION

       version 0.40013

SUMMARY

       This field may be used with the jQuery Datepicker plugin.

       You can specify the format for the date using jQuery formatDate strings or DateTime strftime formats. (Default format is format =>
       '%Y-%m-%d'.)

	  d  - "%e" - day of month (no leading zero)
	  dd - "%d" - day of month (two digit)
	  o  - "%{day_of_year}" - day of the year (no leading zeros)
	  oo - "%j" - day of the year (three digit)
	  D  - "%a" - day name short
	  DD - "%A" - day name long
	  m  - "%{day_of_month" - month of year (no leading zero)
	  mm - "%m" - month of year (two digit) "%m"
	  M  - "%b" - month name short
	  MM - "%B" - month name long
	  y  - "%y" - year (two digit)
	  yy - "%Y" - year (four digit)
	  @  - "%s" - Unix timestamp (ms since 01/01/1970)

       For example:

	  has_field 'start_date' => ( type => 'Date', format => "dd/mm/y" );

       or

	  has_field 'start_date' => ( type => 'Date', format => "%d/%m/%y" );

       You can also set 'date_end' and 'date_start' attributes for validation of the date range. Use iso_8601 formats for these dates ("yyyy-mm-
       dd");

	  has_field 'start_date' => ( type => 'Date', date_start => "2009-12-25" );

       Customize error messages 'date_early' and 'date_late':

	  has_field 'start_date' => ( type => 'Date,
	      messages => { date_early => 'Pick a later date',
			    date_late  => 'Pick an earlier date', } );

       If form has 'is_html5' flag active it will render <input type="date" ... /> instead of type="text"

AUTHOR

       FormHandler Contributors - see HTML::FormHandler

COPYRIGHT AND LICENSE

       This software is copyright (c) 2012 by Gerda Shank.

       This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

perl v5.14.2							    2012-06-25				       HTML::FormHandler::Field::Date(3pm)
All times are GMT -4. The time now is 11:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy