03-06-2013
Grep the last line and put on mail subject
I have mail:
cat /home/oracle/scripts/dbsizedaily.txt | mail -s "$TODAY: PROD DB Size" $RECIPIENTS
I like to get and put USED_GB and %USED of the very last row from
/home/oracle/scripts/dbsizedaily.txt.
/home/oracle/scripts/dbsizedaily.txt has :
HTML Code:
DATE TIME TOTAL_GB USED_GB %USED
......
03/05/2013 21:13 PM 3151.24316 2329.82947 73.9336619
03/05/2013 21:17 PM 3151.24316 2330.17322 73.9445703
so that e-mail subject that contain
"DATE: 03/06/13 - PROD DB Size: 2,330.17 GB - %USED:73.94"
Please advise.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
in a shell script how can I put the result of a grep command in a variable :
myvariable=grep mystring myfilename
Thank you. (3 Replies)
Discussion started by: big123456
3 Replies
2. Shell Programming and Scripting
Hi,
I worte a script which runs perfect when i execute it manually. But when i scheduled into cron the grep command alone is not working.
the sample script,
/usr/bin/grep FTP $subfile > /tmp/tfsrec.dat
tfs=`echo $?`
if
then
echo "FTP FOUND"
else
echo "FTP NOT FOUND"
Where... (5 Replies)
Discussion started by: thiru_cs
5 Replies
3. Shell Programming and Scripting
Dear Experts,
My file contains below-
GET:SUB:ISI,432350414557432;
RESP:0:MD,019352020633:ISI,432350414557432:T11,1:T21,1:T22,1:B16,1:T62,1:BAIC,0:BAOC,1:BOIC,0:BIRO,0:BORO,0:PAID,1;
GET:SUB:ISI,432350414581060;... (2 Replies)
Discussion started by: thepurple
2 Replies
4. UNIX for Advanced & Expert Users
Hi Folk,
Following is the command I used to get data related to the DataFlowEngine.
I wanted to know the % usage of cpu and memory.
ps avg | grep Data
This command will show the processes with its PID as :
PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
... (1 Reply)
Discussion started by: varungupta
1 Replies
5. Shell Programming and Scripting
Dear users,
I googled for a while, but i have got a lot of different answers regarding a simple unix command.
lets say there are a lot of files in a directory.
How can i list the files in a directory whose file types is "text"?
Thank you in advance (4 Replies)
Discussion started by: kevincobain2000
4 Replies
6. Shell Programming and Scripting
Hi Folks,
I am new to ksh, i have informatica parameter file that i need to update everyday with shell script. i need your help updating this file with new parameters.
sample data
$$TABLE1_DATE=04-27-2011
$$TABLE2_DATE=04-23-2011
$$TABLE3_DATE=03-19-2011
.......Highligned... (4 Replies)
Discussion started by: victor369
4 Replies
7. Programming
Dear All,
Could you help me how to put to the next line if I have pattern below in Perl language.
Data-123 Linux MacOSData-124 windows FreeBSDData-125 OpenBSD NetBSD
I would the output below:
Data-123 Linux MacOS
Data-124 windows FreeBSD
Data-125 OpenBSD NetBSD
... (2 Replies)
Discussion started by: askari
2 Replies
8. Shell Programming and Scripting
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; ... (1 Reply)
Discussion started by: sri1977
1 Replies
9. Shell Programming and Scripting
Hi,
I have below script
PROJECT_NAME=UDL/UDL_Weekly
sub= echo ${PROJECT_NAME}|cut -d "/" -f2
cat pr.sh|mail -s "`hostname`: $sub failed" sonu.pal@xyz.com
While running the script I am receiving the subject line in mail as " podetlsapp01: failed' instead of " podetlsapp01: ... (1 Reply)
Discussion started by: sonu_pal
1 Replies
10. UNIX for Dummies Questions & Answers
I am running a mailx command as follows in Linux:
mailx -s "Elapsed Time: " ora_dbas < $RUNDIR/sql_timings.out
I am trying to parse the file "sla_local_sql_timings.out" for the word Elapsed Time: and get the time from that file stored in a variable and display that variable in the subject... (4 Replies)
Discussion started by: vrkcamry
4 Replies
LEARN ABOUT REDHAT
dos2unix
dos2unix(1) General Commands Manual dos2unix(1)
NAME
dos2unix - DOS/MAC to UNIX text file format converter
SYNOPSYS
dos2unix [options] [-c convmode] [-o file ...] [-n infile outfile ...]
Options:
[-hkqV] [--help] [--keepdate] [--quiet] [--version]
DESCRIPTION
This manual page documents dos2unix, the program that converts plain text files in DOS/MAC format to UNIX format.
OPTIONS
The following options are available:
-h --help
Print online help.
-k --keepdate
Keep the date stamp of output file same as input file.
-q --quiet
Quiet mode. Suppress all warning and messages.
-V --version
Prints version information.
-c --convmode convmode
Sets conversion mode. Simulates dos2unix under SunOS.
-o --oldfile file ...
Old file mode. Convert the file and write output to it. The program default to run in this mode. Wildcard names may be used.
-n --newfile infile outfile ...
New file mode. Convert the infile and write output to outfile. File names must be given in pairs and wildcard names should NOT be
used or you WILL lost your files.
EXAMPLES
Get input from stdin and write output to stdout.
dos2unix
Convert and replace a.txt. Convert and replace b.txt.
dos2unix a.txt b.txt
dos2unix -o a.txt b.txt
Convert and replace a.txt in ASCII conversion mode. Convert and replace b.txt in ISO conversion mode. Convert c.txt from Mac to Unix
ascii format.
dos2unix a.txt -c iso b.txt
dos2unix -c ascii a.txt -c iso b.txt
dos2unix -c mac a.txt b.txt
Convert and replace a.txt while keeping original date stamp.
dos2unix -k a.txt
dos2unix -k -o a.txt
Convert a.txt and write to e.txt.
dos2unix -n a.txt e.txt
Convert a.txt and write to e.txt, keep date stamp of e.txt same as a.txt.
dos2unix -k -n a.txt e.txt
Convert and replace a.txt. Convert b.txt and write to e.txt.
dos2unix a.txt -n b.txt e.txt
dos2unix -o a.txt -n b.txt e.txt
Convert c.txt and write to e.txt. Convert and replace a.txt. Convert and replace b.txt. Convert d.txt and write to f.txt.
dos2unix -n c.txt e.txt -o a.txt b.txt -n d.txt f.txt
DIAGNOSTICS
BUGS
The program does not work properly under MSDOS in stdio processing mode. If you know why is that so, please tell me.
AUTHORS
Benjamin Lin - <blin@socs.uts.edu.au>
Bernd Johannes Wuebben (mac2unix mode) <wuebben@kde.org>
MISCELLANY
Tested environment:
Linux 1.2.0 with GNU C 2.5.8
SunOS 4.1.3 with GNU C 2.6.3
MS-DOS 6.20 with Borland C++ 4.02
Suggestions and bug reports are welcome.
SEE ALSO
unix2dos(1) mac2unix(1)
1995.03.31 dos2unix v3.0 dos2unix(1)