03-21-2016
Quote:
Thanks a lot for the above - I have tested that and it works really nicely for what I need - there is just one scenario which I don't think I explained too well before;
That seems to be an understatement. I don't see that you said anything at all about this scenario.
However, reading back through your first post, I did find that my suggestion is incorrect. It only uses COL2 as the key; not COL2, COL3, and COL4. I assume that you can easily modify the code I suggested to fix that deficiency.
Are you now saying that the start year (I assume that you noticed that the code I suggested doesn't care about the month and day values other than to determine whether or not a record needs to be created for the maturity year) is the same for every account in each file you'll be processing? Or, do you have a database somewhere that has to be consulted to find the start date for each different key (i.e., each set of COL2, COL3, and COL4 values)?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have this files:
./frm/lf_mt1_cd.Ic_cell_template.attr
./die/addgen_tb_pumd.Ic_cell_template.attr
./min_m1_n.Ic_cell_template.attr
When I use:
awk -F\/ '{print NF}'
Would result to:
3
3
2
I would like to list the files with 3 fields on it. Any Suggestions? (1 Reply)
Discussion started by: jehrome_rando
1 Replies
2. Shell Programming and Scripting
hi guys, i would like to print two lines from a file as two adjacent columns using excel using awk.. i have this so far:
awk '{for(i=1; i<=NF; i++) {printf("%s\n",$i)}}' "$count".ttt > "$count".csv #this to print the first line from the .ttt file as rows of the first column in the .csv... (9 Replies)
Discussion started by: npatwardhan
9 Replies
3. Shell Programming and Scripting
Hi Guys,
After windows died on my netbook I installed Lubuntu and discovered Gawk about a month ago. After using Excel for 10+ years I'm amazed how quick and easily Gawk can process data but I'm stuck with a little problem merging data from multiple lines.
I'm an SEO Consultant and provide... (9 Replies)
Discussion started by: Jamesfirst
9 Replies
4. Shell Programming and Scripting
Hi,
I would like to delete lines in /etc/hosts on few workstations, basically I want to delete all the lines for a list of machines like this :
for HOST in $(cat stations.lst |uniq)
do
# echo -n "$HOST"
if ping -c 1 $HOST > /dev/null 2>&1
then
HOSTNAME_val=`rsh $HOST "sed... (3 Replies)
Discussion started by: albator1932
3 Replies
5. Shell Programming and Scripting
Hi All,
I'm looking to use AWK to pattern match lines in XML file - Example patten for below sample would be /^<apple>/
The sample I wrote out is very basic compared to what I am actually working with but it will get me started
I would like to keep the matched line(s) unchanged but have them... (4 Replies)
Discussion started by: rhoderidge
4 Replies
6. Shell Programming and Scripting
I have a need to print nth field based on the parameter passed. Suppose I have 3 fields in a file, passing 1 to the function should print 1st field and so on.
I have attempted below function but this throws an error due to incorrect awk syntax.
function calcmaxlen
{
FIELDMAXLEN=0
... (5 Replies)
Discussion started by: krishmaths
5 Replies
7. UNIX for Dummies Questions & Answers
Hi experts, I have a tab-delimited file with one column containing values separated by a comma. I wish to duplicate the entire line for every value in that comma-delimited field.
For example:
$cat file
4444 4444 4444 4444
9990 2222,7777 6666 2222 ... (3 Replies)
Discussion started by: torchij
3 Replies
8. Shell Programming and Scripting
I have the below plain text file where i have some result, in order to mail that result in html table format I have written the below script and its working well. cat result.txt
Page 2015-01-01 2000
Colors 2015-02-01 3000
Landing 2015-03-02 4000
#!/bin/sh LOG=/tmp/maillog.txt... (1 Reply)
Discussion started by: close2jay
1 Replies
9. Shell Programming and Scripting
Hello ,
I will need your help once again.
I have the following file:
cat file02.txt
PATTERN XXX.YYY.ZZZ. 500
ROW01 aaa. 300 XS 14
ROW 45 29 AS XD.FD.
PATTERN 500 ZZYN002
ROW gdf gsste
ALT 267 fhhfe.ddgdg.
PATTERN ERE.MAY. 280
PATTERRNTH 5000 rt.rt.
ROW SO a 678
PATTERN... (2 Replies)
Discussion started by: alex2005
2 Replies
10. Shell Programming and Scripting
The awk below uses the tab-delimeted fileand reformats each line based on one of three conditions (rules). The 3 rules are for deletion (lines in blue), snv (line in red), and insertion (lines in green). I have included all possible combinations of lines from my actual data, which is very large.... (0 Replies)
Discussion started by: cmccabe
0 Replies
CONJUNCT(1) General Commands Manual CONJUNCT(1)
NAME
conjunct - find dates of equinox or new or full moon
SYNOPSIS
conjunct [options]
DESCRIPTION
conjunct searches for one of these events: spring equinox (default), summer solstice, autumn equinox, winter solstice, new moon, or full
moon.
OPTIONS
-s, --start date
Set starting date (default is current date). The date may be either a Julian day number (e.g. 2454180.0 for noon, 2007 March 20) or
an ISO 8601 date (e.g. 2007-03-20).
-e, --end date
Set ending date (default is one year from now).
-V, --vernal, --spring
Search for spring equinox (default).
-S, --summer
Search for summer solstice.
-A, --autumn, --fall
Search for autumn equinox.
-W, --winter
Search for winter solstice.
-N, --newmoon
Search for new moon.
-F, --fullmoon
Search for full moon.
-h, --help
Show summary of options.
SEE ALSO
aa(1).
AUTHOR
conjunct was written by Stephen L. Moshier <steve@moshier.net>.
This manual page was written by James R. Van Zandt <jrv@debian.org>, for the Debian project (but may be used by others).
August 24, 2006 CONJUNCT(1)