05-16-2006
awk question
I have pipe delimited files. For every row in File1 I want to get the matching quote and 3 previous quotes from File2 (match based on date and time) and I want to display the results side by side as shown in File3 - I have to use awk only... any ideas?
File1 has the following data
ID|SYMB|TRADE DATE|PRICE
1892|MSFT|04/01/2006 10:35:42|23.09
1893|IBM|04/01/2006 10:44:22|83.88
1896|MSFT|04/03/2006 14:14:54|23.34
1897|IBM|04/04/2006 15:03:09|83.33
File2 has
SYMB|QUOTE TIME|QUOTE PRICE
MSFT|04/01/2006 10:35:42|23.08
IBM|04/01/2006 10:44:22|83.88
MSFT|04/02/2006 11:01:11|23.18
MSFT|04/02/2006 12:22:31|23.01
IBM|04/02/2006 12:45:21|83.14
MSFT|04/03/2006 14:01:41|23.05
MSFT|04/03/2006 14:07:32|23.25
MSFT|04/03/2006 14:10:09|23.18
MSFT|04/03/2006 14:14:54|23.05
IBM|04/04/2006 15:03:09|83.09
IBM|04/04/2006 15:08:18|82.98
IBM|04/04/2006 15:11:22|83.13
IBM|04/04/2006 15:18:45|83.43
IBM|04/04/2006 15:26:42|83.46
IBM|04/05/2006 15:44:13|83.50
File3
ID|SYMB|TRADE DATE|PRICE|QUOTE TIME| QUOTE PRICE|QUOTE TIME1|QUOTE PRICE1| QUOTE TIME2|QUOTE PRICE2| QUOTE TIME3|QUOTE PRICE3
1896|MSFT|04/03/2006 14:14:54|23.34|04/03/2006 14:14:54|23.05|04/03/2006 14:10:09|23.18|04/03/2006 14:07:32|23.25|04/03/2006 14:01:41|23.05
Last edited by sharkie60; 05-16-2006 at 03:03 PM..
Reason: Output file correction
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have the following error:
ls -lt | awk 'BEGIN NR > 1 { print $2, $9 }'
Syntax Error The source line is 1.
The error context is
BEGIN >>> NR <<< > 1 { print $2, $9 }
awk: 0602-500 Quitting The source line is 1.
What I want to do is ls a directory, skip the first... (3 Replies)
Discussion started by: lesstjm
3 Replies
2. Shell Programming and Scripting
Hello,
I have the following command that does 2 searches.
awk '{if ($0 ~ /STRING1/) {c++} }{if ( c == 2 ) {sub(/STRING1/,"NEWSTRING") } } { print }' FILE
How do I search up after the first search?
thanks (4 Replies)
Discussion started by: ctcuser
4 Replies
3. Shell Programming and Scripting
i have a little awk script that I use looks this:
awk '{if (FNR==1){print FILENAME; print $0}else print $0}' file1...file2....fi... > bundled.
i have completely forgotten how to unbundle this. I have tried several different approaches and still can not remember how to unbundle the file bundled.... (2 Replies)
Discussion started by: moxxx68
2 Replies
4. Shell Programming and Scripting
I am trying to read through a file, gather the states in that file and change it from an abbreviation to the ful text.
Can anyone provide some assistance.
Thanks!! (4 Replies)
Discussion started by: cnitadesigner
4 Replies
5. Shell Programming and Scripting
How I can rid of the following presentation du -sk /u*/oradata/TEST/*.dbf |awk '{print total+=$1} 1.28003e+06
4.35109e+06
4.36134e+06
4.4535e+06
5.47752e+06
5.48777e+06
7.52554e+06
7.73036e+06
9.06158e+06
:confused: thank you (3 Replies)
Discussion started by: zam
3 Replies
6. UNIX for Dummies Questions & Answers
Hi, in the following script, what does " a=$0} END " mean ?
do we need that ? Thanks
awk '{a=$0} END {for (i=NR; i>=1; i--) print a}' file (3 Replies)
Discussion started by: james94538
3 Replies
7. UNIX for Dummies Questions & Answers
Can anyone help with this this one liner:
nawk -v RS='' '$1=$1' InputFile
What I have in the file:
0.0013985457223116
-0.0002338180925628
0.0
0.0003709430584958
-0.0005763523138347
0.0
And the output I want:
0.0013985457223116 -0.0002338180925628 0.0
0.0003709430584958... (1 Reply)
Discussion started by: mookie123
1 Replies
8. UNIX for Dummies Questions & Answers
I have a script problem that I am not able to solve due my very limited understanding of unix/awk.
This is the contents of test.sh
awk '{print $1}'
From the prompt if I enter:
./test.sh Hello World
I would expect to see "Hello" but all I get is a blank line. Only then if I enter "Hello... (2 Replies)
Discussion started by: JasonHamm
2 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
im using ls -l | xargs | awk '{what ever files here}'
im trying to get something that looks like this... (7 Replies)
Discussion started by: rontopia
7 Replies
10. Shell Programming and Scripting
Hi Experts,
I am trying to get system output to capture inside awk , but not working:
Please advise if this is possible :
I am trying something like this but not working, the output is coming wrong:
echo "" | awk '{d=system ("date") ; print "Current date is:" , d }'
Thanks, (5 Replies)
Discussion started by: rveri
5 Replies
LEARN ABOUT DEBIAN
apertium-rexlsx
apertium-rexlsx(1) apertium-rexlsx(1)
NAME
apertium-rexlsx - This application is part of ( apertium )
This tool is part of the apertium open-source machine translation toolbox: http://www.apertium.org.
SYNOPSIS
apertium-rexlsx [ <input file> [ <output file> ] ]
DESCRIPTION
apertium-rexlsx is an XLSX format processor. It restores the original XLSX formatting the text had before being passed through the aper-
tium-desxlsx deformatter.
OPTIONS
-h, --help
Display this help.
SEE ALSO
apertium-retxt(1), apertium-rertf(1), lt-proc(1), apertium-translator(1) apertium(1).
BUGS
Lots of...lurking in the dark and waiting for you!
AUTHOR
Copyright (c) 2005, 2006 Universitat d'Alacant / Universidad de Alicante. This is free software. You may redistribute copies of it under
the terms of the GNU General Public License <http://www.gnu.org/licenses/gpl.html>.
2006-03-21 apertium-rexlsx(1)