Dear All
I am stuck in one problem. Kindly help me.
I am taking below mention file as input file and want some op file as mention below.
Kindly send me all possible suggestion and query.
Thnaks
Jaydeep
bELOW IS THE INPUT FILE:
*** Connected to BSCANGR ***... (1 Reply)
Hi All,
Can anybody tell me why is there a "0" in my output of $date_today ?
#!/usr/local/bin/perl
$date_today = system "date '+%y%m%d'";
print "$date_today\n";
Output:
$ perl test4
080908
0 (3 Replies)
Dear all
I had input file as mention below and want op as mention.
Kindly let me knw possible ways.
Regards
Jaydeep
INPUT:
RXOTX-48-1
2A 34
2B 35
RXOTX-499-2
2C 32
RXOTX-4-1
2D 23
OUTPUT: (3 Replies)
Hello Team i have a file with following data (as columns).
I need implement a syntax like below for altering table
ALTER TABLE1 TABLENAME
ADD COLUMN COL1 CHAR(5) NOT NULL WITH DEFAULT
ADD COLUMN COL2 CHAR(5)
..
..
ADD COLUMN COLn CHAR(5) NOT NULL... (1 Reply)
Hi I am a newbie here. I tried searching for the solution but I guess I either didn't find it or there hasn't been one posted.
my problem is I spooled the results of a query into a .txt file. When I cat the file the formating looks great. All the columns are aligned. However once I mailx the... (2 Replies)
can anyone one help me....to make date and time format...to following format for my file
DATE TIME
DD- MON- YEAR 24 Hours
I have a need of format like this
12-Jan-2012 in one column, then time in 24 Hours in another column....please help...me...
... (4 Replies)
Hi,
I have a data as follows in some files, i want to change CHAR(2-20) to VARCHAR(2-20). I should not touch any line with CHAR(1)
Example:
Input:
cur_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
prev_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT... (7 Replies)
I need to create a fixed width file based on the column lengths.
lets assume I have six(this may be dynamic) fields each are of different length
column1=6 #size of the column
column2=3
column3=2
column4=3
column5=4
column6=5
I tried below code snippet but it is not working
echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies
LEARN ABOUT DEBIAN
data::formvalidator::constraints::dates
Data::FormValidator::Constraints::Dates(3pm) User Contributed Perl Documentation Data::FormValidator::Constraints::Dates(3pm)NAME
Data::FormValidator::Constraints::Dates - Validate Dates and Times
SYNOPSIS
use Data::FormValidator::Constraints::Dates qw(date_and_time);
# In a DFV profile...
constraint_methods => {
# 'pp' denotes AM|PM for 12 hour representation
my_time_field => date_and_time('MM/DD/YYYY hh:mm:ss pp'),
}
DESCRIPTION
date_and_time
Note: This is a new module is a new addition to Data::FormValidator and is should be considered "Beta".
This constraint creates a regular expression based on the format string passed in to validate your date against. It understands the
following symbols:
Y year (numeric)
M month (numeric)
D day (numeric)
h hour
m minute
s second
p AM|PM
Other parts of the string become part of the regular expression, so you can do perlish things like this to create more complex expressions:
'MM?/DD?/YYYY|YYYY-MM?-DD?'
Internally Date::Calc is used to test the functions.
BACKWARDS COMPATIBILITY
This older, more awkward interface is supported:
# In a Data::FormValidator Profile:
validator_packages => [qw(Data::FormValidator::Constraints::Dates)],
constraints => {
date_and_time_field => {
constraint_method => 'date_and_time',
params=>['MM/DD/YYYY hh:mm:ss pp'], # 'pp' denotes AM|PM for 12 hour representation
},
}
SEE ALSO
o Data::FormValidator
o Data::FormValidator::Constraints::DateTime - This alternative features returning dates as DateTime objects and validating against the
date formats required for the MySQL and PostgreSQL databases.
AUTHOR
Mark Stosberg, <mark@summersault.com>
Featuring clever code by Jan Krynicky.
COPYRIGHT AND LICENSE
Copyright 2003-2005 by Mark Stosberg
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2011-11-25 Data::FormValidator::Constraints::Dates(3pm)