Sponsored Content
Top Forums Shell Programming and Scripting Need to remove the duplicate lines from a log!! Post 302583392 by sim_je on Tuesday 20th of December 2011 10:19:45 AM
Old 12-20-2011
Question Need to remove the duplicate lines from a log!!

Hello Folks,

Can some one help me with the removal of duplicate lines from a log file and send it to another log file. It's bit complicated as two lines are same but only difference is the timestamp, but some lines are uniq. Line has been seperated by colon's.

Log file:
=================================================

FORTE:APP:ERROR:nachversorgung.sh logarchivloeschung.sql FP:CRON:for3 :W:0001:Fehler: ##### Fehler in logarchivloeschung, Anzahl Redologs zu gross, 22 Logs nach 10 Laeufen!!! #####:TM 2011.12.20-12:40:43

FORTE:APP:ERROR:nachversorgung.sh logarchivloeschung.sql FP:CRON:for3 :W:0001:Fehler: ##### Fehler in logarchivloeschung, Anzahl Redologs zu klein, 7 Logs #####:TM 2011.12.19-16:35:36

FORTE:APP:ERROR:nachversorgung.sh logarchivloeschung.sql FP:CRON:for3 :W:0001:Fehler: ##### Fehler in logarchivloeschung, Anzahl Redologs zu gross, 22 Logs nach 10 Laeufen!!! #####:TM 2011.12.16-12:42:55

FORTE:APP:ERROR:nachversorgung.sh logarchivloeschung.sql FP:CRON:for3 :W:0001:Fehler: ##### Fehler in logarchivloeschung, Anzahl Redologs zu klein, 7 Logs #####:TM 2011.12.15-16:32:46

FORTE:APP:ERROR:nachversorgung.sh logarchivloeschung.sql FP:CRON:for3 :W:0001:Fehler: ##### Fehler in logarchivloeschung, Anzahl Redologs zu klein, 7 Logs #####:TM 2011.12.15-12:33:36
==================================================================

It should remove the duplicate lines and display atleast like this & send this data to another file.
==================================================================
FORTE:APP:ERROR:nachversorgung.sh logarchivloeschung.sql FP:CRON:for3 :W:0001:Fehler: ##### Fehler in logarchivloeschung, Anzahl Redologs zu gross, 22 Logs nach 10 Laeufen!!! #####:TM 2011.12.20-12:40:43

FORTE:APP:ERROR:nachversorgung.sh logarchivloeschung.sql FP:CRON:for3 :W:0001:Fehler: ##### Fehler in logarchivloeschung, Anzahl Redologs zu klein, 7 Logs #####:TM 2011.12.19-16:35:36

==================================================================

Only difference b/w lines is time stamp. Hope i m clear..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove Duplicate Lines in File

I am doing KSH script to remove duplicate lines in a file. Let say the file has format below. FileA 1253-6856 3101-4011 1827-1356 1822-1157 1822-1157 1000-1410 1000-1410 1822-1231 1822-1231 3101-4011 1822-1157 1822-1231 and I want to simply it with no duplicate line as file... (5 Replies)
Discussion started by: Teh Tiack Ein
5 Replies

2. Shell Programming and Scripting

how to remove duplicate lines

I have following file content (3 fields each line): 23 888 10.0.0.1 dfh 787 10.0.0.2 dssf dgfas 10.0.0.3 dsgas dg 10.0.0.4 df dasa 10.0.0.5 df dag 10.0.0.5 dfd dfdas 10.0.0.5 dfd dfd 10.0.0.6 daf nfd 10.0.0.6 ... as can be seen, that the third field is ip address and sorted. but... (3 Replies)
Discussion started by: fredao
3 Replies

3. Shell Programming and Scripting

remove duplicate lines using awk

Hi, I came to know that using awk '!x++' removes the duplicate lines. Can anyone please explain the above syntax. I want to understand how the above awk syntax removes the duplicates. Thanks in advance, sudvishw :confused: (7 Replies)
Discussion started by: sudvishw
7 Replies

4. Shell Programming and Scripting

Remove duplicate lines

Hi, I have a huge file which is about 50GB. There are many lines. The file format likes 21 rs885550 0 9887804 C C T C C C C C C C 21 rs210498 0 9928860 0 0 C C 0 0 0 0 0 0 21 rs303304 0 9941889 A A A A A A A A A A 22 rs303304 0 9941890 0 A A A A A A A A A The question is that there are a few... (4 Replies)
Discussion started by: zhshqzyc
4 Replies

5. Shell Programming and Scripting

How do I remove the duplicate lines in this file?

Hey guys, need some help to fix this script. I am trying to remove all the duplicate lines in this file. I wrote the following script, but does not work. What is the problem? The output file should only contain five lines: Later! (5 Replies)
Discussion started by: Ernst
5 Replies

6. Shell Programming and Scripting

Remove lines with duplicate first field

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

7. UNIX for Dummies Questions & Answers

Remove Duplicate Lines

Hi I need this output. Thanks. Input: TAZ YET FOO FOO VAK TAZ BAR Output: YET VAK BAR (10 Replies)
Discussion started by: tara123
10 Replies

8. Shell Programming and Scripting

Remove duplicate lines from a file

Hi, I have a csv file which contains some millions of lines in it. The first line(Header) repeats at every 50000th line. I want to remove all the duplicate headers from the second occurance(should not remove the first line). I don't want to use any pattern from the Header as I have some... (7 Replies)
Discussion started by: sudhakar T
7 Replies

9. Shell Programming and Scripting

Remove lines containing 2 or more duplicate strings

Within my text file i have several thousand lines of text with some lines containing duplicate strings/words. I would like to entirely remove those lines which contain the duplicate strings. Eg; One and a Two Unix.com is the Best This as a Line Line Example duplicate sentence with the word... (22 Replies)
Discussion started by: martinsmith
22 Replies

10. Shell Programming and Scripting

How to remove duplicate lines?

Hi All, I am storing the result in the variable result_text using the below code. result_text=$(printf "$result_text\t\n$name") The result_text is having the below text. Which is having duplicate lines. file and time for the interval 03:30 - 03:45 file and time for the interval 03:30 - 03:45 ... (4 Replies)
Discussion started by: nalu
4 Replies
Path::Dispatcher::Cookbook(3pm) 			User Contributed Perl Documentation			   Path::Dispatcher::Cookbook(3pm)

NAME
Path::Dispatcher::Cookbook - A cookbook for Path::Dispatcher RECIPES
How can I change the path delimiter from a space ' ' to a slash '/'? When importing the Path::Dispatcher::Declarative sugar, specify the "token_delimiter" option for the "default" group. package My::Dispatcher; use Path::Dispatcher::Declarative -base, -default => { token_delimiter => '/', }; Or define a subclass of Path::Dispatcher::Declarative with a "token_delimiter" method: package Web::Dispatcher::Maker; use base 'Path::Dispatcher::Declarative'; use constant token_delimiter => '/'; package My::Dispatcher; use Web::Dispatcher::Maker -base; How can I do rule chaining (like in Catalyst)? You can use a "chain" rule approximate chaining behavior: package MyDispatcher; use Path::Dispatcher::Declarative -base; under show => sub { chain { print "Displaying "; }; on inventory => sub { print "inventory: "; ... }; on score => sub { print "score: "; ... }; }; package main; MyDispatcher->run("show inventory"); # "Displaying inventory: ..." MyDispatcher->run("show score"); # "Displaying score: ..." How can I configure tab completion for shells? First add a dispatcher rule for generating completions based on the path. Here we name it _gencomp, so that if the user types "app _gencomp hel" it will print out the various completions of "hel". on qr/^_gencomps*(.*)/ => sub { my $prefix = shift->pos(1); $prefix = "" if !defined($prefix); print "$_ " for dispatcher->complete($prefix); }; Then tell your shell about how to use _gencomp. For zsh it might look like this (replace "APP" with your binary name): /usr/share/zsh/site-functions/_APP: #compdef APP typeset -a APP_completions APP_completions=($($words[1] _gencomp $words[2,-1])) compadd $APP_completions For bash it might look like this: /etc/bash_completion.d/APP.bash: function _APP_() { COMPREPLY=($($1 _gencomp ${COMP_WORDS[COMP_CWORD]})) } complete -F _APP_ APP perl v5.12.4 2011-08-30 Path::Dispatcher::Cookbook(3pm)
All times are GMT -4. The time now is 09:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy