02-21-2013
Remove duplicate value based on two field $4 and $5
Hi All,
i have input file like below...
CA009156;20091003;M;AWBKCA72;123;;CANADIAN WESTERN BANK;EDMONTON;;2300, 10303, JASPER AVENUE;;T5J 3X6;;
CA009156;20091003;M;AWBKCA72;321;;CANADIAN WESTERN BANK;EDMONTON;;2300, 10303, JASPER AVENUE;;T5J 3X6;;
CA009156;20091003;M;AWBKCA72;231;;CANADIAN WESTERN BANK;EDMONTON;;2300, 10303, JASPER AVENUE;;T5J 3X6;;
DE018774;20091003;M;;;29121731;OLDENBURGISCHE LANDESBANK AG;WEYHE B BREMEN;;;;28844;DE;
DE018202;20091003;M;;;26720028;OLDENBURGISCHE LANDESBANK AG;BAD BENTHEIM;;;;48444;DE;
DE018449;20091003;M;;;26520017;OLDENBURGISCHE LANDESBANK AG;MELLE, WIEHENGEB;;;;49303;DE;
CA009156;20091003;M;CWBKCA61;XXX;;CANADIAN WESTERN BANK;EDMONTON;;2300, 10303, JASPER AVENUE;;T5J 3X6;;
CA009156;20091003;M;CWBKCA61;XXX;;CANADIAN WESTERN BANK;EDMONTON;;2300, 10303, JASPER AVENUE;;T5J 3X6;;
CA009156;20091003;M;CWBKCA61;123;;CANADIAN WESTERN BANK;EDMONTON;;2300, 10303, JASPER AVENUE;;T5J 3X6;;
I want unique output based on $4 .
if different branch code is available for same BIC($4) code and one of the branch code($5) is XXX.only one row will be stored and with branch code as XXX .rest of the rows for the BIC code will not be stored.
here $4 is having 3 bic code with same value"CWBKCA61" with diff branch code in $5 and i want only one BIC code($4) with XXX value ...and if XXX is not present in $5 then i need all record..
condition is given is if among all the branch code ($5) for same BIC code($4) "XXX" is not present then i have to print as usual...duplicate value only remove when XXX is present in among all the Branch code for same Bic code...
and if null value is present in $4 and $5(ex->row 4,5,6) then i have to print as usual no need to remove that value..
please help me....
Last edited by mohan sharma; 02-21-2013 at 05:38 AM..
Reason: code tags...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hii Friends.. I have a huge set of data stored in a file.Which is as shown below
a.dat:
RAO 1869 12 19 0 0 0.00 17.9000 82.3000 10.0 0 0.00 0 3.70 0.00 0.00 0 0.00 3.70 4 NULL
LEE 1870 4 11 1 0 0.00 30.0000 99.0000 0.0 0 0.00 0 0.00 0.00 0.00 0 ... (3 Replies)
Discussion started by: reva
3 Replies
2. Shell Programming and Scripting
Hello to all,
I have this file
2002 1 23 0 0 2435.60 131.70 5.60 20.99 0.89 0.00 285.80 2303.90
2002 1 23 15 0 2436.60 132.90 6.45 21.19 1.03 0.00 285.80 2303.70
2002 1 23 ... (6 Replies)
Discussion started by: joggdial3000
6 Replies
3. Shell Programming and Scripting
Trying to cut down the size of some log files. Now that I write this out it looks more dificult than i thought it would be.
Need a bash script or command that goes sequentially through all lines of a file, and does this:
if field1 (space separated) is the number 2012 print the entire line. Do... (7 Replies)
Discussion started by: ajp7701
7 Replies
4. Shell Programming and Scripting
I have a csv file that I would like to remove duplicate lines based on field 1 and sort. I don't care about any of the other fields but I still wanna keep there data intact. I was thinking I could do something like this but I have no idea how to print the full line with this. Please show any method... (8 Replies)
Discussion started by: cokedude
8 Replies
5. Shell Programming and Scripting
Hi,
How can I remove duplicates from a file based on group on other column? for example:
Test1|Test2|Test3|Test4|Test5
Test1|Test6|Test7|Test8|Test5
Test1|Test9|Test10|Test11|Test12
Test1|Test13|Test14|Test15|Test16
Test17|Test18|Test19|Test20|Test21
Test17|Test22|Test23|Test24|Test5
... (2 Replies)
Discussion started by: yale_work
2 Replies
6. Shell Programming and Scripting
Hi ,
Some time i got duplicated value in my files ,
bundle_identifier= B
Sometext=ABC
bundle_identifier= A
bundle_unit=500
Sometext123=ABCD
bundle_unit=400
i need to check if there is a duplicated values or not if yes , i need to check if the value is A or B when Bundle_Identified ,... (2 Replies)
Discussion started by: OTNA
2 Replies
7. Shell Programming and Scripting
I have file like this:
chr start end
chr15 99874874 99875874 chr15 99875173 99876173 aa1
chr15 99874923 99875923 chr15 99875173 99876173 aa1
chr15 99874962 99875962 chr15 99875173 99876173 aa1
chr1 ... (7 Replies)
Discussion started by: raj_k
7 Replies
8. Shell Programming and Scripting
Dear members, I need to filter a file based on the 8th column (that is id), and does not mather the other columns, because I want just one id (1 line of each id) and remove the duplicates lines based on this id (8th column), and does not matter wich duplicate will be removed.
example of my file... (3 Replies)
Discussion started by: clarissab
3 Replies
9. Shell Programming and Scripting
Hi,
I have a file with many sections in it. Each section is separated by a blank line.
The first line of each section would determine if the section is duplicate or not.
if the section is duplicate then remove the entire section from the file.
below is the example of input and output.... (5 Replies)
Discussion started by: ahmedwaseem2000
5 Replies
10. UNIX for Dummies Questions & Answers
Hi all,
I've got a file that has 12 fields. I've merged 2 files and there will be some duplicates in the following:
FILE:
1. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, 100
2. ABC, 12345, TEST1, BILLING, GV, 20/10/2012, C, 8, 100, AA, TT, (EMPTY)
3. CDC, 54321, TEST3,... (4 Replies)
Discussion started by: tugar
4 Replies
LEARN ABOUT CENTOS
pmdakvm
PMDAKVM(1) Performance Co-Pilot PMDAKVM(1)
NAME
pmdakvm - Linux virtualisation performance metrics domain agent (PMDA)
DESCRIPTION
pmdakvm is a Performance Metrics Domain Agent (PMDA) which exports metric values from the Linux KVM virtualisation subsystem.
Unlike many PMDAs it dynamically enumerates its metric hierarchy, based entirely on the contents of /sys/kernel/debug/kvm.
INSTALLATION
If you want access to the names and values for the kvm performance metrics, do the following as root:
# cd $PCP_PMDAS_DIR/kvm
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/kvm
# ./Remove
pmdakvm is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is
installed or removed.
FILES
$PCP_PMDAS_DIR/kvm/Install
installation script for the pmdakvm agent
$PCP_PMDAS_DIR/kvm/Remove
undo installation script for the pmdakvm agent
$PCP_LOG_DIR/pmcd/kvm.log
default log file for error messages from pmdakvm
SEE ALSO
pmcd(1) and kvm(1).
3.8.10 Performance Co-Pilot PMDAKVM(1)