Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Multi line log files to single line format
Top Forums Shell Programming and Scripting Multi line log files to single line format Post 303020284 by RudiC on Monday 16th of July 2018 07:52:19 AM
Old 07-16-2018
Try
Code:
awk '
NF < 5          {T[3] = T[3] $1
                 T[4] = T[4] $2
                 next
                }
                {if (T[1]) print T[1], T[2], T[3], T[4], T[5]
                 split ($0, T)
                }
END             {print T[1], T[2], T[3], T[4], T[5]
                }
' OFS="\t" file
07/15/2018	17:02:00	TRANSLOG_1700	Server0005_SQL	Missed
07/15/2018	17:02:00	TRANSLOG_1700	Server20048_SQL	Missed
07/15/2018	17:02:00	TRANSLOG_170-0_Server30009	Server30009-CE-DBS0009_SQL	Missed
07/15/2018	17:02:00	TRANSLOG_170-0_Server30009-V9	Server30009-CE-DBS0009V9_S-QL	Missed

This User Gave Thanks to RudiC For This Post:
ranjancom2000
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multi-line output to single line

Hello, How can I take the following output: outputa outputb outputc and turn it into single line ouput, with a single space between each field like below: outputa outputb outputc (7 Replies)
Discussion started by: LinuxRacr
7 Replies

2. Shell Programming and Scripting

Merge multi-lines into one single line

Hi, Can anyone help me for merge the following multi-line log which beginning with a number and time: into one line. For each line need to delete the return and add a space. Please see the red color line. *****Original Log*****... (4 Replies)
Discussion started by: happyday
4 Replies

3. Shell Programming and Scripting

How to use Perl to merge multi-line into single line

Hi, Can anyone know how to use perl to merge the following multi-line information which beginning with "BAM" into one line. For each line need to delete the return and add a space. Please see the red color line. ******Org. Multi-line) BAM admin 101.203.57.22 ... (3 Replies)
Discussion started by: happyday
3 Replies

4. Shell Programming and Scripting

Help on Merge multi-lines into one single line

Hello, Can anyone let me know how to use Perl script to Merge following multi-lines into one single line... ***** Multi-line***** FILE_Write root OK Tue Jul 01 00:00:00 2008 cl_get_path file descriptor = 1 FILE_Write root OK ... (5 Replies)
Discussion started by: happyday
5 Replies

5. Shell Programming and Scripting

How to use Perl to join multi-line into single line

Hello, Did anyone know how to write a perl script to merge the multi-line into a single line where each line with start at timestamp Input--> timestamp=2009-11-10-04.55.20.829347; a; b; c; timestamp=2009-11-10-04.55.20.829347; aa; bb; cc; (5 Replies)
Discussion started by: happyday
5 Replies

6. Shell Programming and Scripting

Merge multi-line output into a single line

Hello I did do a search and the past threads doesn't really solve my issue. (using various awk commands) I need to combine the output from java -version into 1 line, but I am having difficulties. When you exec java -version, you get: java version "1.5.0_06" Java(TM) 2 Runtime... (5 Replies)
Discussion started by: flagman5
5 Replies

7. Shell Programming and Scripting

Multi lines to single line

HI, My input file contains the data as like below: A1234119993 B6271113 Bghjkjk A1234119992 B6271113hi Bghjkjkmkl the output i require is : A1234119993 B6271113 Bghjkjk A1234119992 B6271113hi Bghjkjkmkl Please help me in this. Thanks (6 Replies)
Discussion started by: pandeesh
6 Replies

8. Shell Programming and Scripting

Joining multi-line output to a single line in a group

Hi, My Oracle query is returing below o/p ---------------------------------------------------------- Ins trnas value a lkp1 x a lkp1 y b lkp1 a b lkp2 x b lkp2 y ... (7 Replies)
Discussion started by: gvk25
7 Replies

9. UNIX for Dummies Questions & Answers

Remove multi line and single line comments

Hi, I am trying to remove multi line and single line comments like examples below I have tried this pattern. it works fine for single line comments and multi line comments in a single line only. but this fails when the comments are extended in multiple lines as shown in the comment 2 of... (3 Replies)
Discussion started by: ahmedwaseem2000
3 Replies

10. Shell Programming and Scripting

Help with reformat single-line multi-fasta into multi-line multi-fasta

Input File: >Seq1 ASDADAFASFASFADGSDGFSDFSDFSDFSDFSDFSDFSDFSDFSDFSDFSD >Seq2 SDASDAQEQWEQeqAdfaasd >Seq3 ASDSALGHIUDFJANCAGPATHLACJHPAUTYNJKG ...... Desired Output File >Seq1 ASDADAFASF ASFADGSDGF SDFSDFSDFS DFSDFSDFSD FSDFSDFSDF SD >Seq2 (4 Replies)
Discussion started by: patrick87
4 Replies

LEARN ABOUT BSD

logger

LOGGER(1)						      General Commands Manual							 LOGGER(1)

NAME

       logger - make entries in the system log

SYNOPSIS

       logger [ -t tag ] [ -p pri ] [ -i ] [ -f file ] [ message ...  ]

ARGUMENTS

       -t tag	   Mark every line in the log with the specified tag.

       -p pri	   Enter the message with the specified priority.  The priority may be specified numerically or as a ``facility.level'' pair.  For
		   example, ``-p local3.info'' logs the message(s) as informational level in the local3 facility.  The default is ``user.notice.''

       -i	   Log the process id of the logger process with each line.

       -f file	   Log the specified file.

       message	   The message to log; if not specified, the -f file or standard input is logged.

DESCRIPTION

       Logger provides a program interface to the syslog(3) system log module.

       A message can be given on the command line, which is logged immediately, or a file is read and each line is logged.

EXAMPLES

       logger System rebooted

       logger -p local0.notice -t HOSTIDM -f /dev/idmc

SEE ALSO

       syslog(3), syslogd(8)

4.3 Berkeley Distribution					September 17, 1985							 LOGGER(1)
All times are GMT -4. The time now is 02:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy