|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Extract duplicate rows with conditions
Post 302946445 by jiam912 on Tuesday 9th of June 2015 11:05:46 AM
06-09-2015
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a input file with formating:
6000000901 ;36200103 ;h3a01f496 ;
2000123605 ;36218982 ;heefa1328 ;
2000273132 ;36246985 ;h08c5cb71 ;
2000041207 ;36246985 ;heef75497 ;
Each fields is seperated by semi-comma. Sometime, the second files is... (6 Replies)
Discussion started by: anhtt
6 Replies
2. Shell Programming and Scripting
Hi,
I need to extract lines based on some conditions as explained below:
File format details:
notes:
1. each set starts with AAA only
2. number of columns is fixed
3. number of rows per set may vary (as one set is upto DDD - 4 rows)
Now, if any BBB's 5th column is blank then then... (4 Replies)
Discussion started by: prvnrk
4 Replies
3. Shell Programming and Scripting
I have searched the internet for duplicate row extracting.
All I have seen is extracting good rows or eliminating duplicate rows.
How do I extract duplicate rows from a flat file in unix.
I'm using Korn shell on HP Unix.
For.eg.
FlatFile.txt
========
123:456:678
123:456:678
123:456:876... (5 Replies)
Discussion started by: bobbygsk
5 Replies
4. 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
5. Shell Programming and Scripting
Hi! I have a file as below:
line1
line2
line2
line3
line3
line3
line4
line4
line4
line4
I would like to extract duplicate lines (not unique, triplicate or quadruplicate lines). Output will be as below:
line2
line2
I would appreciate if anyone can help. Thanks. (4 Replies)
Discussion started by: chromatin
4 Replies
6. Shell Programming and Scripting
Hi all,
I want to extract some paragraphs out of a file under certain conditions.
- The paragraph must start with 'fmri'
- The paragraph must contain the string 'restarter svc:/system/svc/restarter:default'
My input is like that :
fmri svc:/system/vxpbx:default
state_time Wed... (4 Replies)
Discussion started by: Armoric
4 Replies
7. Shell Programming and Scripting
Hi I have one file which is containing about 5000 rows and 20 columns
I will just explain about my requirement here briefly with sample file, I have attached also, please help....me..
1 28.25 36.42
5 28.26 36.42
10 28.23 36.43
15 28.22 36.43
20 28.2 36.42
25... (6 Replies)
Discussion started by: nex_asp
6 Replies
8. Shell Programming and Scripting
Hi All,
I need to extract duplicate rows from a file and write these bad records into another file. And need to have a count of these bad records.
i have a command
awk '
{s++}
END {
for(i in s) {
if(s>1) {
print i
}
}
}' ${TMP_DUPE_RECS}>>${TMP_BAD_DATA_DUPE_RECS}... (5 Replies)
Discussion started by: Arun Mishra
5 Replies
9. Shell Programming and Scripting
Hi everyone,
I will appreciate a lot if anyone can help me about a simple issue.
I have a data file, and I need to remove some rows with a given condition.
So here is a part of my data file:
5,14,1,3,3,0,0,-0.29977188269E+01
5,16,1,4,4,0,0,0.30394279900E+02... (4 Replies)
Discussion started by: hayreter
4 Replies
10. Shell Programming and Scripting
Hello
I have a file like this:
> cat examplefile
ghi|NN603762|eee
mno|NN607265|ttt
pqr|NN613879|yyy
stu|NN615002|uuu
jkl|NN607265|rrr
vwx|NN615002|iii
yzA|NN618555|ooo
def|NN190486|www
BCD|NN628717|ppp
abc|NN190486|qqq
EFG|NN628717|aaa
HIJ|NN628717|sss
>
I can sort the file by... (5 Replies)
Discussion started by: CHoggarth
5 Replies
LEARN ABOUT DEBIAN
perlbal::manual
Perlbal::Manual(3pm) User Contributed Perl Documentation Perlbal::Manual(3pm) NAME
Perlbal::Manual - Guide and reference manual for Perlbal VERSION Perlbal 1.78. DESCRIPTION This is the comprehensive guide and reference manual for Perlbal. Perlbal::Manual::Configuration How to configure Perlbal: pools, services, syntax and more. Perlbal::Manual::Contributing How to contribute to Perlbal. Perlbal::Manual::Credits Author and contributor credits for Perlbal. Perlbal::Manual::Debugging How Perlbal's Debugging system works. Perlbal::Manual::FailOver How Perlbal's Fail Over mechanism works. Perlbal::Manual::HighPriority Perlbal's high/low priority queueing system and how to use it. Perlbal::Manual::Hooks Existing hooks and how they work. Perlbal::Manual::Install Installation procedures for Perlbal. Perlbal::Manual::Internals Perlbal's architecture at a glance. Useful for developers. Perlbal::Manual::LoadBalancer Setting up a Perlbal Load Balancing service. Perlbal::Manual::Logging How Perlbal's Logging system works. Perlbal::Manual::Management Setting up a "management" service, connecting to that service and managing Perlbal on-the-fly. Perlbal::Manual::Plugins Known plugins and how to create new ones. Perlbal::Manual::ReverseProxy Setting up a Perlbal "reverse_proxy" service. Perlbal::Manual::Roles Brief description of existing roles. Perlbal::Manual::Selector Setting up a Perlbal "selector" service. Perlbal::Manual::WebServer Setting up a Perlbal "web_server" service. AUTHORS
Bruno Martins and JosA~X Castro. SEE ALSO Perlbal::FAQ. There are sample configuration files under conf/, including samples for using and configuring existing plugins. perl v5.14.2 2011-01-23 Perlbal::Manual(3pm)