10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
2. Shell Programming and Scripting
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>" >>... (1 Reply)
Discussion started by: rozee
1 Replies
3. Solaris
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... (2 Replies)
Discussion started by: tharmendran
2 Replies
4. Solaris
Hi how to send below prstat script output into table format and send through email?
prstat|awk '{ if ($9 >= 5) print $0 }' (17 Replies)
Discussion started by: tharmendran
17 Replies
5. Shell Programming and Scripting
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.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
6. Shell Programming and Scripting
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... (10 Replies)
Discussion started by: joy lobo
10 Replies
7. Shell Programming and Scripting
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.. (3 Replies)
Discussion started by: ginrkf
3 Replies
8. Shell Programming and Scripting
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
------ ... (2 Replies)
Discussion started by: qwertyu
2 Replies
9. UNIX for Dummies Questions & Answers
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... (0 Replies)
Discussion started by: mani_isha
0 Replies
10. Shell Programming and Scripting
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 (4 Replies)
Discussion started by: xjklop2009
4 Replies
dtfits(1) General Commands Manual dtfits(1)
NAME
dtfits - display FITS table
SYNOPSIS
dtfits <table>
DESCRIPTION
dtfits dumps the contents of a FITS table in an ASCII format, either into a user-specified file or on stdout. The output is formatted on a
fixed number of columns to make it readable by human beings. Additional informations are printed out before the table values are dumped,
these informations can be skipped by using the -d option.
Last, if you want to dump the table into an easily parsable format (for a piece of software), you might want to use the -s option which
specifies a character to use as separator. All data fields will be printed out separated by this character only. This allows to use string
parsers to cut down the output lines into tokens by looking for this separator. Fields (lines) will still be delimited by the end-of-line
character. This option produces ASCII tables which are easy to parse for a piece of software but mostly unreadable to human beings.
Notice that dtfits only accepts one single FITS table in input.
OPTIONS
-d Skip information output about the table and column names. Outputs only the table values. Beware that if the FITS file contains sev-
eral extensions, they will all appear one after another, separated only by two blank lines. In that case, it would be preferrable to
keep the complete output and parse out the returned stream to differentiate which data come from where.
-s <char>
Use the character <char> as separator in output. This option is useful if you want to produce a table that should be parsed by a
piece of software (see above description). The separator can only be a single non-null character. To avoid special characters being
interpreted by the shell, it is recommended to provide this character always between simple or double quotes. Example:
dtfits -s '&' table.tfits
If you want to use a special character as separator, such as a tab, use ^V to insert your character, such as:
dtfits -s '^V<TAB>' table.tfits
which means: you type CTRL-V and then the tab key.
SEE ALSO
dfits
FILES
FITS tables are stored into extensions. If there are several tables in a file, they will all be displayed one after another in the same
output stream.
22 Dec 1999 dtfits(1)