Required to get out put of log in tabular format in email body Post: 302978093

Sponsored Content

Top Forums Shell Programming and Scripting Required to get out put of log in tabular format in email body Post 302978093 by mirwasim on Tuesday 26th of July 2016 07:55:10 AM

07-26-2016

Registered User

Required to get out put of log in tabular format in email body

Dears Please support

I have out put in text file and look like below

Code:

fixed inquiries - Click on MAX suffix http://server:port/app
User Details  http://server:port/app
Audit User Detail Action hhttp://server:port/app
fixed inquiries - Click on MAX suffix http://server:port/app
User Details  http://server:port/app
Audit User Detail Action http://server:port/app
fixed inquiries - Click on MAX suffix http://server:port/app

This is one column
fixed inquiries - Click on MAX suffix
This is other column http://server:port/app

I used below command to take output in different html format and it is giving me tabular format but how can i put color because it is white background.which place and how i should update color

Code:

nawk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' ERROR_FILE.log > ERROR_FILE.xls

fixed inquiries - Click on MAX suffix
and i want script to consider above in one column
like before http it should be in one column and later should be in other

please support to help me add color and also help me make my output come in two columns

Last edited by RudiC; 07-26-2016 at 09:19 AM.. Reason: Changed some ICODE tags to CODE tags.

mirwasim

View Public Profile for mirwasim

Find all posts by mirwasim

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to put subject and body to mail from two files

Hi all, My sample file is something like this, ORA-00206: Message 206 not found; product=RDBMS; facility=ORA ORA-00202: Message 202 not found; product=RDBMS; facility=ORA ORA-27063: Message 27063 not found; product=RDBMS; facility=ORA ORA-00206: Message 206 not found; ...

2. UNIX for Dummies Questions & Answers

Put data into tabular form

Hi I am having a file which is required to be presented in the under-noted output form. Please suggest. Input: Kapil: apple 4 banana 6 cherry 0 Manoj: apple 13 banana cheery 2 Output: apple banana cherry Kapil: 4 6 0 Manoj: 13 2 Thanks in...

3. UNIX for Dummies Questions & Answers

Put data in tabular form..

Dear Friends, I have a file as under : +++ ME 12-06-13 18:16:20 A RED FEW AND ROW1 1MN FEL AS HI FI BV LR TS HR ES MR * 0 13296 0 120 1 15 KS RR 10 0 +++ ME 12-06-13 18:26:20 A RED FEW AND ROW2 1MN FEL AS...

4. Shell Programming and Scripting

Displaying output in the tabular format

Hi I want to display the following input data into the tabular format as shown in the output. Input.txt: Following jobs are in pending state for more than 10 minutes: JOB_ID JOB_SUBMIT_ID MAHAR 784308 PUNJA 109367 Following jobs are running for longer time: JOB_ID...

5. Shell Programming and Scripting

Outlook Email Body Format Issue

Hello All, I been trying to get a solution for a while not able to figure out. I am generating a file and sending that as an body of message to my outlook account. For some reason reason everything is showing up as one line in the email. for i in `cat "${GEN_PARAM_LIST3}"` do ...

6. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

7. Shell Programming and Scripting

Body content is in random format while sending email from Linux to my outlook.

Hi I have a script running in lunix machine which emails log file content to my outlook. Here is the actual log file result: Image-1 In-Master:25028 ReplicaDn Consumer Supplier Delay dc=xxx,dc=com lmjker0110:12345 ...

8. Shell Programming and Scripting

Fetching the required data out of a tabular form

Hello Gurus, I am trying to fetch a required number of lines from an output of a command which is in tabular form. Below is the command for reference along with how the result is being shown on UNIX shell. /usr/openv/volmgr/bin/vmquery -b -p 5 The result of the above command is as...

9. Shell Programming and Scripting

Adding a blank line in between two O/Ps in tabular format which gets received over email

Hi Guys, I am stuck in between and seeking help here. Requirement: A script that will run every morning which will connect to Mysql database and run the query to inform us about the holidays (it will also check if there were any holidays during last 2 business days). So the three queries are...

10. Shell Programming and Scripting

To have a mail in tabular format

Hello Guys, developing a monitoring shell script to have my queue depth count over mail . here is the sample input file to the script which has all the queue names 1 : DISPLAY QUEUE(*) WHERE (CURDEPTH GT 0) ZFC8409: Display Queue details. QUEUE(QL.GVR.ATA.CACHE.01) ...

LEARN ABOUT DEBIAN

bp_search2tribe

BP_SEARCH2TRIBE(1p)					User Contributed Perl Documentation				       BP_SEARCH2TRIBE(1p)

NAME

       search2tribe - Turn SearchIO parseable reports(s) into TRIBE matrix

SYNOPSIS

       Usage:
	 search2tribe [-o outputfile] [-f reportformat] [-w/--weight] file1 file2 ..

DESCRIPTION

       This script is probably too slow for most people's uses.  It is better to use something like scripts/searchio/fastam9_to_table, -m 9 output
       from BLAST, or the blast2table from the BLAST O'Reilly book to get a tabular output from these programs and then feed the table into MCL
       with the mcxdeblast script and the --m9 option.

       This script will turn a protein Search report (BLASTP, FASTP, SSEARCH) into a Markov Matrix for TribeMCL clustering.

       The options are:

	  -o filename	       - the output filename [default STDOUT]
	  -f format	       - search result format (blast, fasta)
				 (ssearch is fasta format). default is blast.
	  -w or --weight VALUE - Change the default weight for E(0.0) hits
				 to VALUE (default=200 (i.e. 1e-200) )
	  -h		       - this help menu

       Additionally specify the filenames you want to process on the command-line.  If no files are specified then STDIN input is assumed.  You
       specify this by doing: search2tribe < file1 file2 file3

AUTHOR

       Jason Stajich, jason-at-bioperl-dot-org

perl v5.14.2							    2012-03-02						       BP_SEARCH2TRIBE(1p)