Sponsored Content
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:
 

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
TQSLCERT(1)						      General Commands Manual						       TQSLCERT(1)

NAME
TrustedQSL - digitally sign amateur radio contact logs SYNOPSIS
tqslcert [certificate-file]... tqsl [OPTIONS] [log-file]... DESCRIPTION
TrustedQSL is a file format and set of procedures that is used to send digitally signed QSL information (logs of contacts between amateur radio operators). One notable service that makes use of TrustedQSL is ARRL's Logbook of the World. The tqslcert program is used to generate requests for digital certificates and to store the resulting received digital certificates. The tqsl program is used to digitally sign contact log files using a digital certificate. This manual page briefly documents the tqslcert and tqsl programs. Complete documentation is also available: tqslcert: file:///usr/share/TrustedQSL/help/tqslcert/main.htm tqsl: file:///usr/share/TrustedQSL/help/tqslapp/main.htm OPTIONS
tqslcert accepts TQSL certificate files which may optionally be specified on the command line. tqsl accepts these command line options: -d Suppress date-range dialog. If present, the QSO date-range dialog will not be shown for files that follow this option on the command line. -l location_name Selects an existing station location. This location will be used for the commands that follow. If the station location doesn't exist, tqsl will just exit. -o output_file Writes the resulting signed log file to output_file instead of a default name based on the input log-file name. -s Add or edit station location. If there is a preceding -l option the specified location will be edited. If there is no preceding -l option, a new station location is being added. -x (or) -q Exit tqsl. If this argument is used it should be the last one on the command line. If this argument is not present, tqsl will begin normal operation after successfully processing all command-line arguments. log-files Any command-line parameter that is not an option or an option's argument will be treated as the name of a log file (ADIF or Cabrillo) to be signed. The resulting signed file (.tq8) will be placed in the same directory as the log file, overwriting any existing .tq8 file of the same name. (Note: If this option is not preceded by a -l option that selects the station location to be used for signing, the Select Station Location for Signing dialog will be presented.) File names that contain spaces or other shell- special characters should be quoted in a manner suitable for the operating system and shell that's being used. N.B.: If the private key needed to sign a log is protected by a password, the user will be prompted to supply that password for each file being signed. AUTHOR
trustedqsl was written by "American Radio Relay League, Inc.". This manual page was prepared by Kamal Mostafa <kamal@whence.com>, for the Debian project (and may be used by others). March 31, 2011 TQSLCERT(1)
All times are GMT -4. The time now is 03:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy