I want query output to send on mail using table tag and output should be in table Post: 302934832

Sponsored Content

Top Forums Shell Programming and Scripting I want query output to send on mail using table tag and output should be in table Post 302934832 by rbatte1 on Wednesday 11th of February 2015 08:04:51 AM

02-11-2015

Moderator

I have completely misunderstood your requirement. It's not entirely clear what you need, so do you want the output to look more like this?:-

Code:

Pending 
  -----------   ----------  ---------   -
| 16612969688 | 11-FEB-15 |       707 | P |
| 16309354405 | 09-FEB-15 |       152 | P |
| 14049529349 | 08-FEB-15 |       183 | P |
| 16462516471 | 03-FEB-15 |       179 | P |

Activating
  -----------   ----------  ---------   -
| 12485580879 | 10-FEB-15 |       156 | I |
| 16097271993 | 09-FEB-15 |       156 | I |
| 15202489178 | 07-FEB-15 |       183 | I |
| 15057305084 | 07-FEB-15 |       183 | I |
| 13615489396 | 07-FEB-15 |       183 | I |
| 17022926929 | 05-FEB-15 |       183 | I |
| 13602235799 | 05-FEB-15 |       183 | I |
| 15713314401 | 05-FEB-15 |       183 | I |
| 16236285136 | 04-FEB-15 |       156 | I |
| 19103369407 | 02-FEB-15 |       156 | I |
| 19544713197 | 31-JAN-15 |       156 | I |
| 18326291677 | 09-JAN-15 |       174 | I |
| 15302079579 | 29-DEC-14 |       173 | I |

Do you want the output like this (to feed into a spreadsheet, for example) :-

Code:

Pending
16612969688,11-FEB-15,       707,P
16309354405,09-FEB-15,       152,P
14049529349,08-FEB-15,       183,P
16462516471,03-FEB-15,       179,P

Activating
12485580879,10-FEB-15,       156,I
16097271993,09-FEB-15,       156,I
15202489178,07-FEB-15,       183,I
15057305084,07-FEB-15,       183,I
13615489396,07-FEB-15,       183,I
17022926929,05-FEB-15,       183,I
13602235799,05-FEB-15,       183,I
15713314401,05-FEB-15,       183,I
16236285136,04-FEB-15,       156,I
19103369407,02-FEB-15,       156,I
19544713197,31-JAN-15,       156,I
18326291677,09-JAN-15,       174,I
15302079579,29-DEC-14,       173,I

if you could post some expected results (in CODE tags) then that gives us a target to work on.

Robin

rbatte1

View Public Profile for rbatte1

Visit rbatte1's homepage!

Find all posts by rbatte1

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Arrange Data in table and send by mail

Everybody, can you tell me how express about this; we have text data file as : parameter1 Parameter2 AA 55 BB 77 . . . . . . We want to draw table for this data as attached then send as body of Email

2. UNIX for Dummies Questions & Answers

How to send html file in a mail not as an attachment but it should display in the mail in table for

Hi The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment . cat Employee.sql SET VERIFY OFF SET PAGESIZE 200 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON - HEAD...

3. Shell Programming and Scripting

Mailx command - send mail as table format

I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong. Intended Output in mail body: Col1 Col2 Col3 ------ ...

4. Shell Programming and Scripting

Take Data From a table and send it through mail

Hi can anyone help me in writing a code for taking data from a table and need to send that data through mail using mail -x command..

5. Shell Programming and Scripting

[Solved] Shell script output in HTML or with table like results and mail

Hello, Currently i have a script which will disply the results in plain text format. I want to format the result in more readable format like Making bold headings and format with colors etc. Something like html and send that content as email. Please help me how i can do that. I am using...

6. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data....

7. Solaris

How to output the prstat into table and send through email?

Hi how to send below prstat script output into table format and send through email? prstat|awk '{ if ($9 >= 5) print $0 }'

8. Solaris

SQL QUERY to Table Output

Hi I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p inner join v$session se on p.addr = se.paddr inner join ( select...

9. Shell Programming and Scripting

Table to send mail

I have two details to send in html email, two details present in variables, Processname & date which I need to send html email in table. Column1 is Processname: Process1 & column 2 is date:16/6/16 4:55 AM I have below basic html code, how to create table in html to send mail echo "<html>" >>...

10. Shell Programming and Scripting

How to create a file from output of vertica table query in UTF-8 format?

Hello, In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data. file -i filename.csv - gives...

LEARN ABOUT CENTOS

__gnu_cxx::temporary_buffer

__gnu_cxx::temporary_buffer< _ForwardIterator, _Tp >(3)      Library Functions Manual	   __gnu_cxx::temporary_buffer< _ForwardIterator, _Tp >(3)

NAME

       __gnu_cxx::temporary_buffer< _ForwardIterator, _Tp > -

SYNOPSIS

       Inherits std::_Temporary_buffer< _ForwardIterator, _Tp >.

   Public Types
       typedef pointer iterator
       typedef value_type * pointer
       typedef ptrdiff_t size_type
       typedef _Tp value_type

   Public Member Functions
       temporary_buffer (_ForwardIterator __first, _ForwardIterator __last)
       ~temporary_buffer ()
       iterator begin ()
       iterator end ()
       size_type requested_size () const
       size_type size () const

   Protected Attributes
       pointer _M_buffer
       size_type _M_len
       size_type _M_original_len

Detailed Description
   template<class _ForwardIterator, class _Tp = typename std::iterator_traits<_ForwardIterator>::value_type>struct __gnu_cxx::temporary_buffer<
       _ForwardIterator, _Tp >
       This class provides similar behavior and semantics of the standard functions get_temporary_buffer() and return_temporary_buffer(), but
       encapsulated in a type vaguely resembling a standard container.

       By default, a temporary_buffer<Iter> stores space for objects of whatever type the Iter iterator points to. It is constructed from a
       typical [first,last) range, and provides the begin(), end(), size() functions, as well as requested_size(). For non-trivial types, copies
       of *first will be used to initialize the storage.

       malloc is used to obtain underlying storage.

       Like get_temporary_buffer(), not all the requested memory may be available. Ideally, the created buffer will be large enough to hold a copy
       of [first,last), but if size() is less than requested_size(), then this didn't happen.

       Definition at line 183 of file ext/memory.

Constructor &; Destructor Documentation
   template<class _ForwardIterator , class _Tp	= typename std::iterator_traits<_ForwardIterator>::value_type> __gnu_cxx::temporary_buffer<
       _ForwardIterator, _Tp >::temporary_buffer (_ForwardIterator__first, _ForwardIterator__last) [inline]
       Requests storage large enough to hold a copy of [first,last).

       Definition at line 186 of file ext/memory.

   template<class _ForwardIterator , class _Tp	= typename std::iterator_traits<_ForwardIterator>::value_type> __gnu_cxx::temporary_buffer<
       _ForwardIterator, _Tp >::~temporary_buffer () [inline]
       Destroys objects and frees storage.

       Definition at line 190 of file ext/memory.

Member Function Documentation
   template<typename _ForwardIterator, typename _Tp> iterator std::_Temporary_buffer< _ForwardIterator, _Tp >::begin () [inline],  [inherited]
       As per Table mumble.

       Definition at line 151 of file stl_tempbuf.h.

       Referenced by std::inplace_merge(), std::stable_partition(), and std::stable_sort().

   template<typename _ForwardIterator, typename _Tp> iterator std::_Temporary_buffer< _ForwardIterator, _Tp >::end () [inline],  [inherited]
       As per Table mumble.

       Definition at line 156 of file stl_tempbuf.h.

   template<typename _ForwardIterator, typename _Tp> size_type std::_Temporary_buffer< _ForwardIterator, _Tp >::requested_size () const [inline],
       [inherited]
       Returns the size requested by the constructor; may be >size().

       Definition at line 146 of file stl_tempbuf.h.

       Referenced by std::stable_partition().

   template<typename _ForwardIterator, typename _Tp> size_type std::_Temporary_buffer< _ForwardIterator, _Tp >::size () const [inline],
       [inherited]
       As per Table mumble.

       Definition at line 141 of file stl_tempbuf.h.

       Referenced by std::inplace_merge(), std::stable_partition(), and std::stable_sort().

Author
       Generated automatically by Doxygen for libstdc++ from the source code.

libstdc++							  Tue Jun 10 2014	   __gnu_cxx::temporary_buffer< _ForwardIterator, _Tp >(3)