11-23-2009
gawk help for inserting a field of a .txt file in the same file
i had the following type of data file vchrdump:
Vouchers For Date :05/01/2009 *
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
ENTRY 4 13 FLDAIRY 20070038 GANDLA SIVA VARA PRASAD 9,400.00 GSD RRR
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total Debits For Date 05/01/2009 :
Total Credits : 9,400.00
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Vouchers For Date :06/01/2009
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
TR-INT 6 11 FLDAIRY 20070011 GANI DIBBAMMA SB 5662 3.00 GSD BSR
ENTRY 16 82 FLDAIRY 20070011 GANI DIBBAMMA SB 5662 3.00 GSD BSR
ENTRY 16 83 FLDAIRY 20070011 GANI DIBBAMMA SB 5662 84.00 GSD BSR
ENTRY 9 46 FLDAIRY 20070022 DUDEKULA UMAYULU SB 7023 400.00 GSD BSR
i want the date part of 'Vouchers For Date :05/01/2009' to be inserted at the begining of each row till the next date comes..and so on...
i tried the following command:
BEGIN {i=0} NF>10 && NF<16{print $0 ; i++ } i==999 NEXT
which gave the data as under:
ENTRY 4 13 FLDAIRY 20070038 GANDLA SIVA VARA PRASAD 9,400.00 GSD RRR
TR-INT 6 11 FLDAIRY 20070011 GANI DIBBAMMA SB 5662 3.00 GSD BSR
ENTRY 16 82 FLDAIRY 20070011 GANI DIBBAMMA SB 5662 3.00 GSD BSR
ENTRY 16 83 FLDAIRY 20070011 GANI DIBBAMMA SB 5662 84.00 GSD BSR
pl.. help by refining my above mentioned command
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am using a database text file with a field that increments +1 with each new entry, occasionally if a entry is deleted the unique sequence is disrupted.
I am looking for a small script/function in sh and/or perl that would re index this.
Example of db file:
Name | Address | misc |number... (2 Replies)
Discussion started by: silenthands
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I have already read a lot of posts on sending attachments in unix...but none of them were of help for my problem...so here goes..
i wanna attach a text file and send to a mail id..used the following code :
uuencode "$File1" "$File1" ;|mail -s "$Mail_sub" abc@abc.com
it works... (2 Replies)
Discussion started by: ash22
2 Replies
3. Shell Programming and Scripting
Hi,
Please guide me where i am doing wrong, i am getting
ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.
Please find below the code where log file variable is myLogFile. Please let me know where i am doing wrong.
... (0 Replies)
Discussion started by: rajeshorpu
0 Replies
4. UNIX for Dummies Questions & Answers
Hello,
Hoping someone can help!
I have a file (fileA) with a potentially different number of | delimited fields the file looks like:
fileA
A|B|C|D|E|F|G|
A|B|C|D|E|F|G|
This file could have 100+ fields and have 2million+ records
I have another file (fileB) which contains an 8 digit... (3 Replies)
Discussion started by: dendright
3 Replies
5. Shell Programming and Scripting
Hi all,
I did not use UNIX for a long time, now i need to make a flat file with extra field, can you help me with the code ?
1. I create a last line of each log from each system and make it in a flat text file (seperate by a pipe |)
mv current.log old
tail -1 sanfrancisco.log > current.log... (5 Replies)
Discussion started by: britney
5 Replies
6. Shell Programming and Scripting
I have a '|' delimited file.
My file looks like below
23|nationalhoilday|feb12||||||||||||||california|northdistrict||
In the same way, each record has 164 fields. I have to insert one more field after the 85th field.
Expected output... (3 Replies)
Discussion started by: machomaddy
3 Replies
7. Shell Programming and Scripting
Hello Mates,
I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G
SE18 6RN,,,,5439070,1786840,,1000002148671600,123434
Out put should be:
SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434
Can some one help me to... (8 Replies)
Discussion started by: krsnadasa
8 Replies
8. UNIX for Dummies Questions & Answers
I have a csv flatfile with a few million rows. I need to replace a field (field number is 85) in the file with a sequential number.
As an example, let's assume there are only 4 fields in the file:
A,A,,32
A,A,,27
A,B,,43
C,C,,354
If I wanted to amend the 3rd field in this way my... (2 Replies)
Discussion started by: BristolSmithy
2 Replies
9. Shell Programming and Scripting
Hi All,
I have the input as below:
cat input
032016002 2.891 97.109 16.605 27.172 24.017 32.207 0.233 0.021 39.810 0.077 0.026 19.644 13.882 0.131 11.646 0.102 11.449 76.265 23.735 16.991 83.009 8.840 91.160 0.020 99.980 52.102 47.898 44.004 55.996 39.963 18.625 0.121 1.126 40.189... (15 Replies)
Discussion started by: am24
15 Replies
10. UNIX for Beginners Questions & Answers
Hi there,
I am having this problem:
a) I am uploading a txt file from windows (notepad) with some Gaussian 09 command lines;
b) Gaussian needs in certain command files, that those files have a blank line at the end of the file!
c) I open the command file with vi and no blank line at the of... (2 Replies)
Discussion started by: luismga
2 Replies
LEARN ABOUT MOJAVE
date::calc::pp
Date::Calc::PP(3) User Contributed Perl Documentation Date::Calc::PP(3)
NAME
Date::Calc::PP - pure-Perl plug-in for Date::Calc
SYNOPSIS
You never use this module directly. Use Date::Calc(3) instead!
DESCRIPTION
You never use this module directly. Use Date::Calc(3) instead!
SEE ALSO
Date::Calc(3), Date::Calc::XS(3).
VERSION
This man page documents "Date::Calc::PP" version 6.3.
AUTHOR
Steffen Beyer
mailto:STBEY@cpan.org
http://www.engelschall.com/u/sb/download/
COPYRIGHT
Copyright (c) 1995 - 2009 by Steffen Beyer. All rights reserved.
LICENSE
This package is free software; you can use, modify and redistribute it under the same terms as Perl itself, i.e., at your option, under the
terms either of the "Artistic License" or the "GNU General Public License".
The C library at the core of the module "Date::Calc::XS" can, at your discretion, also be used, modified and redistributed under the terms
of the "GNU Library General Public License".
Please refer to the files "Artistic.txt", "GNU_GPL.txt" and "GNU_LGPL.txt" in the "license" subdirectory of this distribution for any
details!
DISCLAIMER
This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the "GNU General Public License" for more details.
perl v5.18.2 2009-10-30 Date::Calc::PP(3)