Sponsored Content
Top Forums Shell Programming and Scripting AWK Compare previous value with current. Post 302509451 by rdcwayx on Wednesday 30th of March 2011 09:33:05 PM
Old 03-30-2011
Init the input file:

Code:
$ cat infile
1,mnq,1
1,ddd,2
1,ddd,3
1,sss,4
1,ddd,5
1,add,6
1,fff,7
1,ddr,8
1,rrd,9
1,der,10
2,mnq,11
3,pqr,12
4,pqr,13
5,pqr,14
12,adhe,0
13,add,1

Get the output:
Code:
$ awk -F , '{if (!a[$2]) {a[$2]=$3} else {$3=a[$2]}}1' OFS="," infile
1,mnq,1
1,ddd,2
1,ddd,2
1,sss,4
1,ddd,2
1,add,6
1,fff,7
1,ddr,8
1,rrd,9
1,der,10
2,mnq,1
3,pqr,12
4,pqr,12
5,pqr,12
12,adhe,0
13,add,6

For your second request, I guess you need export to different files depend on the number on column 3.

Code:
awk -F , '{if (!a[$2]) {a[$2]=$3} else {$3=a[$2]}}1' OFS="," infile |awk -F , '{print >$3 ".txt"}'

after that, you will get file 1.txt, 12.txt, etc.
This User Gave Thanks to rdcwayx For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

to write a script to compare the file size in the current directory and previous dir

hi, i am new to this site. i want to write a script to compare the file size of the files in the current dir with the files in the previous directory. the files name will be same, but the filename format will be as xyzddddyymm.txt. the files will arrive with the month end date(i want to... (5 Replies)
Discussion started by: tweety
5 Replies

2. UNIX for Advanced & Expert Users

Compare two files using awk or sed, add values in a column if their previous fields are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output files as follows In my above example, each row in file1 has 6 fields and each row in file2 has 3... (1 Reply)
Discussion started by: yerruhari
1 Replies

3. UNIX for Dummies Questions & Answers

Compare two files using awk or sed, add values in a column if their previous fields are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output files as follows In my above example, each row in file1 has 6 fields and each row in file2 has 3... (1 Reply)
Discussion started by: yerruhari
1 Replies

4. Shell Programming and Scripting

Compare two files using awk or sed, add values in a column if their previous fields are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output files as follows In my above example, each row in file1 has 6 fields and each row in file2 has 3... (3 Replies)
Discussion started by: yerruhari
3 Replies

5. UNIX for Dummies Questions & Answers

Awk to print data from current and previous line

Hi guys, I have found your forum super useful. However, right now I am stuck on a seemingly "simple" thing in AWK. I have two columns of data, the first column in Age (in million years) and the second column is Convergence Rate (in mm/yr). I am trying to process my data so I can use it to... (2 Replies)
Discussion started by: awk_noob_456
2 Replies

6. Shell Programming and Scripting

Compare Field in Current Line with Field in Previous

Hi Guys I have the following file Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above: Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Discussion started by: moutaye
9 Replies

7. Shell Programming and Scripting

How to compare current record,with next and previous record in awk without using array?

Hi! all can any one tell me how to compare current record of column with next and previous record in awk without using array my case is like this input.txt 0 32 1 26 2 27 3 34 4 26 5 25 6 24 9 23 0 32 1 28 2 15 3 26 4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies

8. Shell Programming and Scripting

Perl to send previous and current value

For example, I have a file called number.txt. x y 1 1 2 4 3 9 4 6 5 5 6 6 7 9 8 4 9 1 10 0 ... And I want to print out the value of x and y, if y%4==0 and the next value of y%4==0. Thus, the sample output is: 1 1 *because the previous x before 2 is 1 2 4 *because 4%4 == 0 7 9... (2 Replies)
Discussion started by: Tzeronone
2 Replies

9. Shell Programming and Scripting

How to compare the current result with previous line result.?

Hi Gurus, I have requirement to compare current result with previous reuslt. The sample case is below. 1 job1 1 1 job2 2 1 job3 3 2 job_a1 1 2 job_a2 2 2 job_a3 3 3 job_b1 1 3 job_b2 2 for above sample file, GID is group ID, for input line, the job run... (1 Reply)
Discussion started by: ken6503
1 Replies

10. Shell Programming and Scripting

How to compare previous and current item in for loop in bash?

Hey, I am trying to compare formated login and logout dates from one user at a host which I have stored in a tmp directory in order to find out the total login time. I need to compare them in order to find overlapping intervals. At first I tried to store each log in and logo date in an array... (3 Replies)
Discussion started by: Mumu123
3 Replies
PMNUMBERSTR(3)						     Library Functions Manual						    PMNUMBERSTR(3)

NAME
pmNumberStr, pmNumberStr_r - fixed width output format for numbers C SYNOPSIS
#include <pcp/pmapi.h> const char *pmNumberStr(double value); char *pmNumberStr_r(double value, char *buf, int buflen); cc ... -lpcp DESCRIPTION
pmNumberStr returns the address of a 8-byte buffer that holds a null-byte terminated representation of value suitable for output with fixed width fields. The pmNumberStr_r function does the same, but stores the result in a user-supplied buffer buf of length buflen, which should have room for at least 8 bytes. The value is scaled using multipliers in powers of ``one thousand'' (the decimal ``kilo'') and has a bias that provides greater precision for positive numbers as opposed to negative numbers. The format depends on the sign and magnitude of value as follows (d represents a decimal digit): +----------------------------------+---------+ | value range | format | +----------------------------------+---------+ | > 999995000000000 | inf? | |999995000000000 - 999995000000 | ddd.ddT | | 999995000000 - 999995000 | ddd.ddG | | 999995000 - 999995 | ddd.ddM | | 999995 - 999.995 | ddd.ddK | | 999.995 - 0.005 | ddd.dd | | 0.005 - -0.005 | 0.00 | | -0.005 - -99.95 | -dd.dd | | -99.995 - -99995 | -dd.ddK | | -99995 - -99995000 | -dd.ddM | | -99995000 - -99995000000 | -dd.ddG | | -99995000000 - -99995000000000 | -dd.ddT | | < -99995000000000 | -inf? | +----------------------------------+---------+ At the boundary points of the ranges, the chosen format will retain the maximum number of significant digits. NOTES
pmNumberStr returns a pointer to a static buffer and hence is not thread-safe. Multi-threaded applications should use pmNumberStr_r instead. SEE ALSO
printf(3) Performance Co-Pilot PCP PMNUMBERSTR(3)
All times are GMT -4. The time now is 05:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy