Sponsored Content
Top Forums Shell Programming and Scripting Adding a blank line in between two O/Ps in tabular format which gets received over email Post 303002670 by RudiC on Wednesday 30th of August 2017 11:54:25 AM
Old 08-30-2017
Once we start optimizing / improving the script, why not put everything together into one single loop:
Code:
DT=(20170811 20170831)
for i in 0 1
  do    echo "<table border=1>"
        mysql test -e "select c.CenterID,a.MIC,c.ExchangeName,a.CountryCode,a.EventDate,a.EventDayOfWeek,b.eventName from exch_calendar_event a left join exch_calendar_eventName b on a.EventID=b.ID left join exch_calendar_mic c on a.MIC=c.MIC where EventDate=DATE_FORMAT(${DT[$i]},'%Y%m%d') order by a.MIC;" |
          while read LINE
            do  echo "<tr><td>${LINE//	/<\/td><td>}</td></tr>"
            done
        echo "</table><br>"
  done | sendmail -t


Last edited by RudiC; 08-30-2017 at 06:03 PM..
This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

adding blank line in egrep

I followed the egrep example given in the thread "parse text or complex grep ?". It is exactly what I need...except... how do I insert a blank line after the second line? My exact command is: egrep 'patt1|patt2' filename the result is: patt1 patt2 patt1 patt2 and so on. I would... (2 Replies)
Discussion started by: antalexi
2 Replies

2. Shell Programming and Scripting

Need help in sed command (adding a blank line btw each block generated by pattern)

Hello friends, I have a C source code containing sql statements. I use the following sed command to print all the sql blocks in the source code.... sed -n "/exec sql/,/;/p" Sample.cpp The above sed command will print the sql blocks based on the pattern "exec sql" & ";"... (2 Replies)
Discussion started by: frozensmilz
2 Replies

3. Shell Programming and Scripting

SED - adding blank line after each Range Match

the following range matching works great but i wish to add a blank line after each range result set... which i've tried and researched to no avail MY INPUT DATA: CURRENT CODE I'M USING: sed -n '/*$/,/;/p' $INPUT_FILE RESULTS I'M GETTING: RESULT I looking to... (5 Replies)
Discussion started by: danmauer
5 Replies

4. Shell Programming and Scripting

Fill the empty line by adding line before blank line

FIle A "A" 2 aa 34 3 ac 5 cd "B" 3 hu 67 4 fg 5 gy output shud be A"" 2 aa 34 "A" 3 ac 34 "A" 5 cd 34 "B" 3 hu 67 "B" 4 fg 67 "B" 5 gy 67 (6 Replies)
Discussion started by: cdfd123
6 Replies

5. Shell Programming and Scripting

Adding a blank line after every 5th line

Hello... I have a file which contain certain number of records. I want to generate another file from this file which will contain 1st line as a blank line & after every 5 lines one blank line will be inserted. How to achieve this through shell scripting? Thanks... (5 Replies)
Discussion started by: 46019
5 Replies

6. Shell Programming and Scripting

sed adding a blank line

I use the following as part of a script to correct for a faulty hostname file. # get the domain name read -r thehostname < /etc/hostname dom="$(echo $thehostname | cut -d'.' -f2)" numchar=${#dom} if then echo "It appears as though the hostname is not correctly set." echo "Hostname has... (5 Replies)
Discussion started by: bugeye
5 Replies

7. 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... (1 Reply)
Discussion started by: dats
1 Replies

8. 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... (6 Replies)
Discussion started by: dani1234
6 Replies

9. Shell Programming and Scripting

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 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 ... (13 Replies)
Discussion started by: mirwasim
13 Replies

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) ... (10 Replies)
Discussion started by: wims
10 Replies
MIC-CHROOT(1)						      General Commands Manual						     MIC-CHROOT(1)

NAME
mc-chroot - chroot into a live image in order to do some changes SYNOPSIS
mic-chroot [options] <image|image fs> <image> is a live image file name, <image fs> is a directory path which contains the whole file system unpacked from a live image. DESCRIPTION
mic-chroot can chroot into a live image to do some changes, you can use it to unpack a live image then do some changes, once changes are done, you can regenerate a live image including those changes you did. mic-image-manager has a GUI tool for mic-chroot, you can use it if you prefer to use GUI instead of command line. OPTIONS
--version show version number -h, --help show this help message -s SAVETO, --save-to=SAVETO Save unpacked filesystem to the specified path --unpack-only Just unpack an image, this is used tounpack an image with -s option together -b BINDMOUNTS, --bind-mounts=BINDMOUNTS Specify bind mount list, for example: -b "/proc:/proc;/:/parentroot" -c CONVERTTO, --convert-to=CONVERTTO Convert it to the specified type live image on exiting, the allowed value is livecd or liveusb --convert-only Just convert an image, this will skip chroot and directly convert an image/filesytem with -c option together -o OUTDIR, --outdir=OUTDIR Output directory to use (default: current work dir) EXAMPLES
Unpack an image to a directory and chroot into it: mic-chroot -s /my/fs/root EXIT STATUS
mic-image-convertor returns a zero exist status if it succeeds, otherwise return non-zero and print error message. AUTHOR
Yi Yang, Anas Nashif, Jianfeng Ding SEE ALSO
mic-image-creator(1), mic-convertor(1), mic-image-writer(1), mic-livecd-iso-to-disk(1), mic-image-manager(1) perl v5.12.3 2011-05-31 MIC-CHROOT(1)
All times are GMT -4. The time now is 02:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy