How to insert new line in the data file using the script

Sona · #1 (**permalink**) 08-17-2006

Hi all,

I have a test.dat file.In that file i have many lines of data.
IN between some lines i want to insert a new line while running the test.ksh.

Say for ex:
In the dat file i have data like

N001 100.00
N001 200.00
N001 300.00
N001 400.00 <==
After this line i want to insert line like
N001 1000.00 ( total of all the N001 data).
N002 100.00
N002 200.00
N002 300.00
N002 400.00

Please tell me how i can do this by runnin ga script.

Thanks in Advance,
Sona.

vgersh99 · #2 (**permalink**) 08-17-2006

nawk -f sona.awk test.dat

sona.awk:

Code:

FNR==1 {f1=$1}
{
   if ( $1 == f1 )
      t+=$2
   else {
     printf("%s%s%.2f\n", f1, OFS, t); f1=$1; t=$2
   }
}
1
END { printf("%s%s%.2f\n", f1, OFS, t) }

Sona · #3 (**permalink**) 08-22-2006

Hi,

Thanks for your response.Can you please explain this piece of code.i could not understand the code.

Thanks,
Sona.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
unable Insert data from .dat file to .xls can anybody help me	kreddy2003	Shell Programming and Scripting	1	05-28-2008 05:33 AM
How to insert data into MYSql database from a text file	shirleyeow	Shell Programming and Scripting	4	01-11-2008 05:00 AM
find the position in a file and insert the data there	isingh786	HP-UX	5	04-11-2006 09:31 PM
sed, insert data from a file to another?	ctcuser	Shell Programming and Scripting	4	05-03-2005 01:43 PM
Insert a line as the first line into a very huge file	shriek	UNIX for Advanced & Expert Users	3	03-09-2005 01:22 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by