Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Check Date Format And Email Out
Top Forums Shell Programming and Scripting Check Date Format And Email Out Post 302854383 by Ariean on Tuesday 17th of September 2013 10:59:40 AM
Old 09-17-2013
Check Date Format And Email Out
Hello All,
I have a requirement where i need to get the EXTRACT_DATE from a file and check if the date is of valid format or not and then mail it if it is not valid. Appreciate if you can help me with this.

I did the following so far.

Code:
awk '{for(i=1;i++<=NF;)if($i~/^EXTRACT_DATE/) print $i}' FCBTEXAS_v1.xml

got the following output
Code:
EXTRACT_DATE="2012-12-31"

Now i want to connect to Oracle sqlplus and pass this "2012-12-31" as an input parameter to following sql and write into log file and then grep for error message in log file if the to_date function errors out because of bad date format/data and then email out the error message.

Code:
select to_date('2012-12-31','yyyy-mm-dd') from dual

Appreciate your help and if there is another better way of handling this in shell scripting itself instead of connecting to Oracle DB to perform validation.

Thanks much.
Last edited by vbe; 09-17-2013 at 12:19 PM.. Reason: code tags not icode...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check for the correct date format in UNIx

Hi All, I am getting two input from User for Date from the command prompt when my script is executed . The date format i am taking is : DD-MM-YYYY so is there any method in Unix to validate the two input date. There might be many cases for these two date to be invalid.... (1 Reply)
Discussion started by: rawatds
1 Replies

2. Shell Programming and Scripting

Check the format of Date

Hi, I have a date field in my input file. I just want to check if its in the format "DD-MM-YYYY". Is there any command which can achieve this? Thanks and Regards, Abhishek (2 Replies)
Discussion started by: AAA
2 Replies

3. UNIX for Dummies Questions & Answers

Any simple method to check date format (YYDDD)?

Hi Guru's, Are there any simple method to check the date format which is in "YYDDD" (ex: 08002 for 02-Jan-2008)? Eventhough this can be implemented in several way's, I need the simpler one. Any idea would be much appreciated. Thanks in advance, Mysore Ganapati (4 Replies)
Discussion started by: ganapati
4 Replies

4. Shell Programming and Scripting

Check input date format?

how to check input date format. for example $input_date must be in format dd.mm.gg script is execute like this: bin/script1.sh 14.12.2009 script1.sh code: #!/bin/sh input_date=$1 CMD="/app/si/test/test.sh $input_date" echo "*****" $CMD (2 Replies)
Discussion started by: waso
2 Replies

5. Shell Programming and Scripting

Need to check date format yyyymm

My source file having one date column. The formate of the date column is yyyymm. I need to validate whether all the rows are in same format in the given file. If it is not I have captured that records in a separate file. I am very new to Unix. I don't how to achieve this. Plz help me to achieve... (2 Replies)
Discussion started by: suresh01_apk
2 Replies

6. Shell Programming and Scripting

Date format check and replace string in PERL

I have got few date format patterns like "yyyymmdd", "yy_mm_dd" etc. There can be any combination of such patterns. I have used add_delta_days to find "yyyy", "yy", "mm", "dd" for the current date and saved them to different variables like "$y1", "$y2", "$m1" etc In one line, i want to... (10 Replies)
Discussion started by: irudayaraj
10 Replies

7. Shell Programming and Scripting

PERL : hhmiss - Date format check and replace

I have a filename, This can be any of any format, I want to check if the filename has hours,mins and seconds part. If it is present, i want to replace it with a " * " (star symbol) output needed: IMP: The time part can be in any pattern. How can this be done?:confused:... (3 Replies)
Discussion started by: irudayaraj
3 Replies

8. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

9. Shell Programming and Scripting

How to check if date format is correct?

Hi! how do i know if the input is the same as the required date format? the date should be dd/mm/YYYY ex. 2/3/2012 or 15/11/2012 all the following conditions must return an error: *input of string *day is > 31 or < 1 *month is > 12 or < 1 *year is < 2013 suppose the date format is stored... (1 Reply)
Discussion started by: angilulu
1 Replies

10. Shell Programming and Scripting

Command to check date format DDMMYYYY

Record: Record1|Record2|Record3|Record4|Record5|DATE1|DATE2 Need to Check DATE1 & DATE2 is in DDMMYYYY format in a file. records which not meet the date format DDMMYYYY extract to other file. (1 Reply)
Discussion started by: vivekn
1 Replies

LEARN ABOUT DEBIAN

conflict

CONFLICT(8)							     [nmh-1.5]							       CONFLICT(8)

NAME

       conflict - search for alias/password conflicts

SYNOPSIS

       /usr/lib/mh/conflict [-search directory] [-mail name] [-version] [-help] [aliasfiles ...]

DESCRIPTION

       Conflict is a program that checks to see if the interface between nmh and the transport system is in good shape

       Conflict also checks for maildrops in /var/mail which do not belong to a valid user.  It assumes that no user name will start with `.', and
       thus ignores files in /var/mail which begin with `.'.  It also checks for entries in the group(5) file which do not belong to a valid user,
       and for users who do not have a valid group number.  In addition duplicate users and groups are noted.

       If  the	-mail  name  switch is used, then the results will be sent to the specified name.  Otherwise, the results are sent to the standard
       output.

       The -search directory switch can be used to search directories other than /var/mail and to report  anomalies  in  those	directories.   The
       -search directory switch can appear more than one time in an invocation to conflict.

       Conflict should be run under cron(8), or whenever system accounting takes place.

FILES

       /etc/nmh/mts.conf	  nmh mts configuration file
       /etc/passwd		  List of users
       /etc/group		  List of groups
       /usr/bin/mh/mhmail	  Program to send mail
       /var/mail/		  Directory of mail drop

PROFILE COMPONENTS

       None

SEE ALSO

       mh-alias(5)

DEFAULTS

       `aliasfiles' defaults to /etc/nmh/MailAliases

CONTEXT

       None

MH.6.8								   11 June 2012 						       CONFLICT(8)
All times are GMT -4. The time now is 05:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy