12-20-2011
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
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
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
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
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
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
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
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
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
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
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
uulog(1) General Commands Manual uulog(1)
NAME
uulog - Displays UUCP log files
SYNOPSIS
/usr/lib/uucp/uulog -f system [-number]
uulog
uulog systems [-number]
uulog -s system [-number]
uulog -x [systems]
The uulog command displays the contents of a log file of uucico or uuxqt activities.
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
uulog: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
OPTIONS
[Tru64 UNIX] Performs a tail -f on the file transfer log for the specified system, displaying the end of the log file. Use the Interrupt
key sequence to leave the file and return to the prompt. Prints information about copy requests involving the specific system. If no sys-
tem is specified, information is displayed for all systems.
Note: System name can contain only ASCII characters. [Tru64 UNIX] Displays the uuxqt log file for the specified systems. If no
systems are specified, information is displayed for all systems. [Tru64 UNIX] Displays the last lines of the log file. The number
of lines is determined by the number argument. (To display the lines, the uulog command issues a tail for the specified number of
lines.)
DESCRIPTION
Individual log files are created for each remote system with which the local system communicates using the uucp, uusend, uuto, or uux com-
mands.
Use the uulog command to display a summary of uucp, uusend, uuto, and uux command requests by a system or systems. All of these transac-
tions are logged in files under the /usr/spool/uucp/.Log/ directory. The files are named daemon_name/system, where the daemon_name direc-
tory is named for the daemon involved and the system file is named for the remote system the daemon is contacting.
The uucp and uuto commands call the uucico daemon. The uucico activities are logged in the system file in the /usr/spool/uucp/.Log/uucico
directory.
The uux and uusend commands call the uuxqt daemon. The uuxqt activities are logged in the /usr/spool/uucp/.Log/uuxqt/system file.
You can examine these individual log files by issuing the uulog command directly. However, you can also have these temporary log files
appended to a primary log file that you can then examine. This is called compacting the log files and is handled by uudemon.cleanu, a
shell script in /usr/lib/uucp.
NOTES
The uulog utility is marked LEGACY in XCU Issue 5.
EXAMPLES
To display the uucico log file for system hera, enter: uulog -s hera [Tru64 UNIX] To display the uuxqt log file, enter: uulog -x [Tru64
UNIX] To display the last forty lines of the file transfer log for system zeus, enter: uulog -f zeus -40 To display the uucico log file
for systems pluto and venus, enter: uulog pluto venus [Tru64 UNIX] To display the uuxqt log file for systems pluto and venus, enter: uulog
-x pluto venus
FILES
Contains log files. Public directory.
SEE ALSO
Commands: ct(1), cu(1), tail(1), tip(1), uucico(8), uucleanup(8), uucp(1), uuencode(1), uudecode(1), uuname(1), uupick(1), uusched(8),
uusend(1), uustat(1), uuto(1), uux(1)
Standards: standards(5)
uulog(1)