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.
got the following output
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.
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...
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)
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)
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)
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)
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)
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)
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)
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)
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)
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 HPUX
dtsearchvaliddatestring
DtSearchValidDateString(library call) DtSearchValidDateString(library call)
NAME
DtSearchValidDateString -- Validate and convert a user date string
SYNOPSIS
#include <Dt/Search.h>
DtSrObjdate DtSearchValidDateString(
char *date_string);
DESCRIPTION
DtSearchValidDateString validates a DtSearch date string, as might have been entered by a user in a free form text field, and converts it
into a valid DtSrObjdate.
Since an invalid date string format returns a distinctive DtSrObjdate, this function may also be used as a boolean test for string valid-
ity.
ARGUMENTS
date_string
Specifies the date string to be validated and converted.
The format for a valid date string is "[yyyy [mm [dd]]", one, two, or three ASCII numeric tokens separated by one or more nonnu-
meric chars (whitespace, slashes, etc). The integer yyyy represents a Gregorian calendar year number in the range 1990 to 5995
inclusive. If yyyy is less than 1900, 1900 is added to it. The integer mm is a Gregorian calendar month number in the range 1 to
12 inclusive. The integer dd is a Gregorian calendar day number in the range 1 to 31 inclusive.
If only two tokens are in the string, they are presumed to be yyyy and mm, and dd is presumed to be to 1.
If only one token is in the string, it is presumed to be yyyy, and both mm and dd are presumed to be 1.
RETURN VALUE
DtSearchValidDateString returns zero (a valid DtSrObjdate) if date_string is NULL or empty.
It returns a correctly formatted DtSrObjdate on successful parse and conversion.
It returns -1 and a message on the MessageList if date_string is invalid.
SEE ALSO DtSrAPI(3), DtSearchQuery(3), dtsrfzkfiles(4), DtSearch(5)
DtSearchValidDateString(library call)