04-27-2004
Parsing a textfile, sorting and doing math fucntions.
whats up all, I am very happy I joined this forum, I have learned alot just going through.
I have a small dilemma... trying to parse a textfile, and sort by 1st feild and add up second feild....
cat textfile.in
1200, 2.50
1200, 1.00
1200, 3.00
1000, 1.00
1000, 2.00
1500, 10.00
1600, 1.00
1600, 2.00
what I need is for this file to look like this...
1200, 6.50
1000, 3.00
1500, 10.00
1600, 3.00
The way I know how to do this involves grep and tmpfiles, takes a long time, and is basically a big mess.... I wanna know if someone knows like a one line apprach do doing this.
for list in `cat textfile.in | awk -F, '{print $1}' | sort | uniq`
do
>$$.tmp
grep $list textfile.in | awk -F, '{print $2}' >> $$.tmp
# Internal utilty sumfeld adds contents of given feild
totalprice=`sumfld $$.tmp 1`
echo "${list},${totalprice}" >> newfile.txt
done
Last edited by djsal; 04-27-2004 at 01:34 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
need some help from all of you as i'm a beginner in shellscript. Currently i have a textfile(filename.txt) with the below content:
TOTAL: 30
RECORDS: 300
anyone one know how do i plug out the value of 30 and put into a variable(var1) and 300 into another variable(var2)?I'm coding using... (7 Replies)
Discussion started by: snowfrost
7 Replies
2. Shell Programming and Scripting
I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves.
Also, the script should only move a file from /exports to... (6 Replies)
Discussion started by: nikosey
6 Replies
3. Shell Programming and Scripting
Hi,
I have a textfile with several lines like this:
text num: USER text (num) num num
I need all these stuff. Problem is, how to get these stuff after ":".
USER is a username and all chars are possible, even whitespace. So I cant use cut. Any ideas? (3 Replies)
Discussion started by: mcW
3 Replies
4. Shell Programming and Scripting
Hey guys,
I have this file generated by me... i want to create some HTML output from it.
The problem is that i am really confused about how do I go about reading the file.
The file is in the following format:
TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies
5. Shell Programming and Scripting
Tag allerseits
Ich habe ein umfangreiches Script. Darin möchte ich zu Beginn ein textfile lesen. Den ersten Satz.
Dann kommen mehrere Instruktionen und dann soll wieder gelesen werden. Den zweiten Satz.
Etc.
Ich kann also das herkömmliche while read xyz / do ... done nicht benützen.
... (0 Replies)
Discussion started by: lazybaer
0 Replies
6. Shell Programming and Scripting
Hi, I'm starting a little project with a shell script but I'm don't know how to do it. Maybe someone can help me.
I have un text file like this :
I'd like to do a script who will extract from my file from @ADDLINE1@ to @ADDLINE4@ only and I have no idea how to do this.
Any idea ?
... (7 Replies)
Discussion started by: Poulki
7 Replies
7. Shell Programming and Scripting
Hi everyone,
I need to make a script to take three parameters:
-> KEY
-> NEW_VALUE
-> FILE
The FILE is a text plane file.
The KEY is a variable to configure, for example:
KEY1 = HOLA
KEY2= HOLA
KEY3=HELLO
KEY4 =HOLA
And the... (4 Replies)
Discussion started by: Xedrox
4 Replies
8. Windows & DOS: Issues & Discussions
So...
I have a text file that contains this (hex.txt):
#8C7CA6
#6C70A5
#75777C
#959A90
#7A7C6C
#867DAB
#80867E
#8A87BD
#6B71C6
#8F8A79
#9A9DCE
#7E87D0
#69709E
#82968C
#7C8F81
#A3917B (5 Replies)
Discussion started by: pasc
5 Replies
9. Shell Programming and Scripting
My first post, so don't kill me :)
Say i open some textfile with some example like this.
on the table are handy, bread and wine
Now i know exactly what is in and i want to separate and sorted it in terminal to an existing file with another 2 existing lines in like this:
table
plane ... (3 Replies)
Discussion started by: schwatter
3 Replies
10. Shell Programming and Scripting
I want to save a variablecontent in a Textfile. How can i do that?
These works only with ls shell_exec("ls > text.txt");Please use code tags, thanks (2 Replies)
Discussion started by: Linuxmann
2 Replies
VI(1) General Commands Manual VI(1)
NAME
vi, ki, xi - instruction simulators
SYNOPSIS
vi [ textfile ]
vi pid
ki [ textfile ]
ki pid
xi [ textfile ]
xi pid
DESCRIPTION
Vi simulates the execution of a MIPS binary in a Plan 9 environment. It has two main uses: as a debugger and as a statistics gatherer.
Programs running under vi execute about two hundred times slower than normal--but faster than single stepping under db. Ki and xi are sim-
ilar to vi but interpret SPARC and ATT3210 binaries. The following discussion refers to vi but applies to the others as well.
Vi will simulate the execution of a named textfile. It will also make a copy of an existing process with process id pid and simulate its
continuation.
As a debugger vi offers more complete information than db(1). Tracing can be performed at the level of instructions, system calls, or
function calls. Vi allows breakpoints to be triggered when specified addresses in memory are accessed. A report of instruction counts,
load delay fills and distribution is produced for each run. Vi simulates the CPU's caches and MMU to assist the optimization of compilers
and programs.
The command interface mirrors the interface to db; see db(1) for a detailed description. Data formats and addressing are compatible with
db except for disassembly: vi offers only MIPS (db -mmipsco) mnemonics for machine instructions. Ki offers both Plan 9 and Sun SPARC for-
mats.
Several extra commands allow extended tracing and printing of statistics:
$t[0ics]
The t command controls tracing. Zero cancels all tracing options.
i Enable instruction tracing
c Enable call tracing
s Enable system call tracing
$i[itsp]
The i command prints statistics accumulated by all code run in this session.
i Print instruction counts and frequency.
p Print cycle profile.
t (Vi only) Print TLB and cache statistics.
s Print memory reference, working set and size statistics.
:b[arwe]
Vi allows breakpoints to be set on any memory location. These breakpoints monitor when a location is accessed, read, written, or
equals a certain value. For equality the compared value is the count (see db(1)) supplied to the command.
SOURCE
/sys/src/cmd/vi etc.
SEE ALSO
nm(1), db(1)
BUGS
The code generated by the compilers is well supported, but some unusual instructions are unimplemented. Some Plan 9 system calls such as
rfork cause simulated traps. The floating point simulation makes assumptions about the interpreting machine's floating point support. The
floating point conversions performed by vi may cause a loss of precision.
VI(1)