Sponsored Content
Top Forums Shell Programming and Scripting Parsing a textfile, sorting and doing math fucntions. Post 50572 by djsal on Tuesday 27th of April 2004 12:14:39 PM
Old 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

plugging out value from a textfile

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

Finding & Moving Oldest File by Parsing/Sorting Date Info in File Names

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

Parsing textfile problem with cut

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

Parsing of file for Report Generation (String parsing and splitting)

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

Textfile lesson

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

How to extract more than 1 line in a textfile ?

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

Change value in a textFile

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

Use Textfile for variables ?

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

How to separate sorte different characters from one textfile and copy them in a new textfile?

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

Variablecontent in a Textfile

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)
All times are GMT -4. The time now is 04:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy