Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell script to email based on flat file output
Top Forums Shell Programming and Scripting Shell script to email based on flat file output Post 302315217 by apoorva on Monday 11th of May 2009 11:28:52 PM
Old 05-12-2009
Question Shell script to email based on flat file output
Hi All,

I am a newbee in unix but still have written a shell script which should trigger a mail based on certain conditions but the problem is that my file is not being read. Below is the code please advise. I do not know where is it failing.

Note $ and the no followed with it is the no of the column in the Flat file

Code:
HOME=/export/home/ls/report/
$ORACLE_HOME/bin/sqlplus -s user_name/password@database  < /export/home/ls/report/notification.sql  > /export/home/ls/report/filename.txt
cat /export/home/ls/report/filename.txt | 
while read line awk `
BEGIN {
NOTE='Do not respond to this email as it was generated via an automatic process'
}
{
if ( $3 = 'Status' ) (
Content= 'Please move the incident to next status'
if ($7 >= 0 && $7 <= 14 )
                {
                  printf ("\nmailx -r user_name@comapny.com -s "Incident Number :" ,$1 ,$36 ,"-c ",$28",$Content,$NOTE)>> /export/home/ls/report/initial1.txt
                }
  
if ($8 >= 15 && $8 <= 29 )
                {
                  printf ("\nmailx -r user_name@comapny.com  -s "FO Number :" $1 $36 -c $28")
                }
if ($9 >= 30  ) 
                {
                  printf ("\nmailx -r user_name@comapny.com  s %s",$36," %s", $28)
                }
  
  continue
 )            
}
END {
}`

Last edited by Yogesh Sawant; 05-12-2009 at 05:30 AM.. Reason: added code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating email based on an output

Hello folks. I need to create a script that looks at a certain output (list of full paths of files) and gets the owner's name (2nd position in the path, for example: /dirA/jsmith/blah1/more_blah/still_blah... etc) Gets the jsmith and greps the related file for jsmith and send that output to... (1 Reply)
Discussion started by: saswerks
1 Replies

2. Shell Programming and Scripting

urgent-extracting block data from flat file using shell script

Hi, I want to extract block of data from flat file. the data will be like this start of log One two three end of log i want all data between start of log to end of log i.e One two three to be copied to another file. This particular block may appear multiple times in same file. I... (4 Replies)
Discussion started by: shirish_cd
4 Replies

3. Shell Programming and Scripting

Merge lines in Flat file based on first 5 characters

Hi I have the fixed width flat file having the following data 12345aaaaaaaaaabbbbbbbbbb 12365sssssssssscccccccccc 12365sssss 12367ddddddddddvvvvvvvvvv 12367 vvvvv Here the first column is length 5 second is length 10 third is length 10 if the second or third column exceeds... (3 Replies)
Discussion started by: Brado
3 Replies

4. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

5. Shell Programming and Scripting

Shell Script to Reformat a flat file

Hi , I have a text file noname.txt containing 1000+ records like this. One of the record I have given below. Input will b e like this BOT: 2010/06/01 00:25:59 21 = "private" Access-Method = 31 NCC = GBR 01 = "340806@osiris.fr.ft" 04 =... (2 Replies)
Discussion started by: smalya
2 Replies

6. Shell Programming and Scripting

Extracting email addresses from a flat file

All, I have a flat file which contains an email address in every line. I am trying to find a way to extract all the email addresses delimited by comma (,). Can you please show me a way, it will be very helpful, thanks. (3 Replies)
Discussion started by: sed_beginner19
3 Replies

7. UNIX for Dummies Questions & Answers

Read a flat file, evaluate and create output. UNIX SCRIPT.

Hi all, I have a flat file as below; 470423495|1||TSA-A000073800||1|||1 471423495|1||TSA-A000073800||5|||5 472423495|1||TSA-A000073800||2|||7 473423495|1||TSA-A000073800||3|||3 I like to create a Unix script. The script have to valuate the last two columns, if the values are... (4 Replies)
Discussion started by: mrreds
4 Replies

8. Shell Programming and Scripting

SQL query in UNIX script - output in flat file

Hi, I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen. snapshot of my script:... (13 Replies)
Discussion started by: juzz4fun
13 Replies

9. Shell Programming and Scripting

Sort based on positions in flat file

Hello, For example: 12........6789101112..............20212223242526..................50 ( Positions) LName FName DOB (Lastname starts from 1 to 6 , FName from 8 to 15 and date of birth from 21 to29) CURTIS KENNETH ... (5 Replies)
Discussion started by: duplicate
5 Replies

10. Shell Programming and Scripting

Getting data from a flat file based on condition

Hi, I have a flaty file from which i am fetching few columns in tablular form as below code. Now i want to fetch the column 6 and 7 in below code only if it either of them is non zero.However below startement awk -F, '$6==0 && $7==0{exit 1}' ${IFILE} is not working..Not sure where is the... (36 Replies)
Discussion started by: Vivekit82
36 Replies

LEARN ABOUT MOJAVE

nroff_manmacros

doctools::nroff::man_macros(n)					Documentation tools				    doctools::nroff::man_macros(n)

__________________________________________________________________________________________________________________________________________________

NAME

       doctools::nroff::man_macros - Default CSS style for NROFF export plugins

SYNOPSIS

       package require Tcl  8.4

       package require doctools::nroff::man_macros  ?0.1?

       ::doctools::nroff::man_macros::contents

_________________________________________________________________

DESCRIPTION

       This  package  provides a single command providing access to the definition of the nroff man macro set to use for NROFF markup generated by
       the various NROFF export plugins.

       This is an internal package of doctools, for use by export plugins, i.e. the packages converting doctools  related  documented  into  other
       formats, most notably nroff.

API

       ::doctools::nroff::man_macros::contents
	      This command returns the text of the default CSS style to use for NROFF generated by the various NROFF export plugins.

BUGS, IDEAS, FEEDBACK
       This document, and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the category doctools
       of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may have for
       either package and/or documentation.

KEYWORDS

       doctools, export, macros, man_macros, nroff, plugin

CATEGORY

       Documentation tools

COPYRIGHT

       Copyright (c) 2009 Andreas Kupries <andreas_kupries@users.sourceforge.net>

doctools2base								0.1					    doctools::nroff::man_macros(n)
All times are GMT -4. The time now is 04:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy