Sponsored Content
Top Forums Shell Programming and Scripting Pattern to match date in YYYY-MM-DD format on Linux machine Post 303010749 by as7951 on Saturday 6th of January 2018 08:27:30 AM
Old 01-06-2018
Hi Don,

I agree complete error is below only which you have pasted.
My intention was not to hide anything from anyone.
Just to keep it short and simple i pasted the below

Code:
Error 131: Incorrect DocumentDate pattern Field position 14, Linenumber:2

and below is my complete code, to keep is short just removed other validation conditions
Code:
awk -F"|" 'NR>1{
if (length($1)>25) {print "Error 101: Source Identifier exceeds the allowed limit","Field position 1, Linenumber:"NR,$0}
if ($1 ~ /[A-Za-z]+[0-9]+/ || $1 ~ /^[0-9]*$/) {print "Error 102: Source Identifier contains String other than characters","Field position 1, Linenumber:"NR,$0}
if (length($2)>50) {print "Error 103: Source File name excceds the allowed limit","Field position 2, Linenumber:"NR,$0}
if (length($14)>10) {print "Error 130: DccumentDate pattern exceeds allowed limit", "Linenumber:"NR,$0}
if ($14 !~ /^[0-9]{4}\-(0[1-9]|1[0-2])\-(0[1-9]|[1-2][0-9]|3[0-1])$/) {print "Error 131: Incorrect DocumentDate pattern", "Field position 14, Linenumber:"NR,$0}
if ($11 ~ /^CAN$/ && $13==$15) {print "Error 208: column 13 and column 15 matches ","Field position 13, Linenumber:"NR,$0}
if ($3 ~ /[^A-Za-z0-9]+/ || $3 != "") {print "Error 209: GLACode contains string contain space","Field position 3, Linenumber:"NR,$0}
#{printf var1}
printf("\n")
}' /Scripts/gt/test1.txt > aj.txt

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create filename with 'DD/MM/YYYY' date format

Hi, I can use the following command to create a file with some name then underscore and then date appended to it in the format 'DD-MM-YYYY': touch "newfile_`date '+%d-%m-%Y'`" But it gives me error when I try with the similar command to create a file with the date format 'DD/MM/YYYY'. I... (4 Replies)
Discussion started by: royalibrahim
4 Replies

2. UNIX for Dummies Questions & Answers

Format date from MM/DD/YYYY to YYYYMMDD

I have a file with some date columns in MM/DD/YYYY format: SMPBR|DUP-DO NOT USE|NEW YORK||16105|BA5270715|6/6/2007 |MWERNER|109||||JOHN||SMITH|MD|72211118||||||74559|21 WILMINGTON RD||D|11/6/2003|SL# MD CONTACT-LIZ RICHARDS|||0|Y|N||1411458| And I want to convert the date format to: ... (5 Replies)
Discussion started by: ChicagoBlues
5 Replies

3. Shell Programming and Scripting

date and time in mm/dd/yyyy hh:mm format

Frens, I have a logfile which has got manier things in it and somewer in that file i have a date in mm/dd/yyyy hh:mm format.... I just need to get the date and time nothing else.... i have searched in this forum for it but got only date in mm-dd-yyyy format.. but i need to search for... (10 Replies)
Discussion started by: smarty86
10 Replies

4. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies

5. Shell Programming and Scripting

Need date in the format [mm dd yyyy hh AM/PM]

could you please help be on the below code .. Requirement is when i pass the parameter(for below 2) i should get current time -2 hours in the format :wall:.. cur_dt=`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID -P $PASSWD -h -C"select getdate()" | sed '2d'` pr_dt="`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID... (2 Replies)
Discussion started by: karthicss
2 Replies

6. Shell Programming and Scripting

need code for date which is in yyyy-mm-dd format

Hi, I am having one log files. contains som data according to date. And it is going to append .Eg:abc.log contains below data 2011-10-19 abjhgj 2011-10-19 gjhgjgj 2011-10-20 hhhjh 2011-10-20 hhhhjj 2011-10-21 gg . . . 2011-11-24 yyy from log files i want catch only... (2 Replies)
Discussion started by: aish11
2 Replies

7. Shell Programming and Scripting

Convert any date format into yyyy/mm/dd

How can I convert any user inputted date into yyyy/mm/dd ? For example user can input date one of the following 20120121 , 2012-01-21 ,01/21/2012,01/21/2012 etc But I need to convert any of the date entered by user into yyyy/mm/dd (2012/01/2012). Any suggestion. Thanks in advance this is... (1 Reply)
Discussion started by: ZeroHedge
1 Replies

8. Shell Programming and Scripting

Date Format MM/DD/YYYY

I am changing epoch times to dates. I was able to do the following: echo "$varx" | gawk '{print strftime("%c", $0)}' Mon Dec 31 16:26:40 2012 This changes the epoch date (which is what varx is) into localtime. However, my problem is that I only want 12/31/2012 and not the Mon Dec 31... (2 Replies)
Discussion started by: newbie2010
2 Replies

9. Shell Programming and Scripting

How to get last 12 month date in YYYY.MM format?

I need the date format in YYYY.MM format and I am able to get current month date as well as previous month date with below command PM=`date +'%Y.%m' -d 'last month'` CM=`date +'%Y.%m' -d 'now'` but I need to get YYYY.MM date format for previous 12 months so could you please help me how I get... (2 Replies)
Discussion started by: Amit Joshi
2 Replies

10. Shell Programming and Scripting

Date format YYYY/MM/DD to DD/MM/YYYY

I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY. When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD file... (3 Replies)
Discussion started by: Roozo
3 Replies
Mail::Message::Field::Addresses(3pm)			User Contributed Perl Documentation		      Mail::Message::Field::Addresses(3pm)

NAME
Mail::Message::Field::Addresses - Fields with e-mail addresses INHERITANCE
Mail::Message::Field::Addresses is a Mail::Message::Field::Structured is a Mail::Message::Field::Full is a Mail::Message::Field is a Mail::Reporter SYNOPSIS
my $cc = Mail::Message::Field::Full->new('Cc'); my $me = Mail::Message::Field::Address->parse('"Test" <test@mail.box>') or die; my $other = Mail::Message::Field::Address->new(phrase => 'Other' , address => 'other@example.com') or die; $cc->addAddress($me); $cc->addAddress($other, group => 'them'); $cc->addAddress(phrase => 'third', address => 'more@any.museum' , group => 'them'); my $group = $cc->addGroup(name => 'collegues'); $group->addAddress($me); $group->addAddress(phrase => "You", address => 'you@example.com'); my $msg = Mail::Message->build(Cc => $cc); print $msg->string; my $g = Mail::Message::Field::AddrGroup->new(...); $cc->addGroup($g); DESCRIPTION
All header fields which contain e-mail addresses only. Not all address fields have the same possibilities, but they are all parsed the same: you never know how broken the applications are which produce those messages. When you try to create constructs which are not allowed for a certain kind of field, you will be warned. OVERLOADED
overload: ""() See "OVERLOADED" in Mail::Message::Field overload: +0() See "OVERLOADED" in Mail::Message::Field overload: <=>() See "OVERLOADED" in Mail::Message::Field overload: bool() See "OVERLOADED" in Mail::Message::Field overload: cmp() See "OVERLOADED" in Mail::Message::Field overload: stringification() See "OVERLOADED" in Mail::Message::Field::Full METHODS
Constructors $obj->clone() See "Constructors" in Mail::Message::Field Mail::Message::Field::Addresses->from(FIELD, OPTIONS) See "Constructors" in Mail::Message::Field::Full Mail::Message::Field::Addresses->new() -Option --Defined in --Default attributes Mail::Message::Field::Structured <ignored> charset Mail::Message::Field::Full undef datum Mail::Message::Field::Structured undef encoding Mail::Message::Field::Full 'q' force Mail::Message::Field::Full false language Mail::Message::Field::Full undef log Mail::Reporter 'WARNINGS' trace Mail::Reporter 'WARNINGS' attributes => ATTRS charset => STRING datum => STRING encoding => 'q'|'Q'|'b'|'B' force => BOOLEAN language => STRING log => LEVEL trace => LEVEL The field $obj->isStructured() Mail::Message::Field::Addresses->isStructured() See "The field" in Mail::Message::Field $obj->length() See "The field" in Mail::Message::Field $obj->nrLines() See "The field" in Mail::Message::Field $obj->print([FILEHANDLE]) See "The field" in Mail::Message::Field $obj->size() See "The field" in Mail::Message::Field $obj->string([WRAP]) See "The field" in Mail::Message::Field $obj->toDisclose() See "The field" in Mail::Message::Field Access to the name $obj->Name() See "Access to the name" in Mail::Message::Field $obj->name() See "Access to the name" in Mail::Message::Field $obj->wellformedName([STRING]) See "Access to the name" in Mail::Message::Field Access to the body $obj->body() See "Access to the body" in Mail::Message::Field $obj->decodedBody(OPTIONS) See "Access to the body" in Mail::Message::Field::Full $obj->folded() See "Access to the body" in Mail::Message::Field $obj->foldedBody([BODY]) See "Access to the body" in Mail::Message::Field $obj->stripCFWS([STRING]) Mail::Message::Field::Addresses->stripCFWS([STRING]) See "Access to the body" in Mail::Message::Field $obj->unfoldedBody([BODY, [WRAP]]) See "Access to the body" in Mail::Message::Field Access to the content $obj->addAddress([ADDRESS], OPTIONS) Add an ADDRESS to the field. The addresses are organized in groups. If no group is specified, the default group is taken to store the address in. If no ADDRESS is specified, the option must be sufficient to create a Mail::Message::Field::Address from. See the OPTIONS of Mail::Message::Field::Address::new(). -Option--Default group '' group => STRING $obj->addAttribute(...) Attributes are not supported for address fields. $obj->addGroup(GROUP|OPTIONS) Add a group of addresses to this field. A GROUP can be specified, which is a Mail::Message::Field::AddrGroup object, or one is created for you using the OPTIONS. The group is returned. -Option--Default name '' name => STRING $obj->addresses() Returns a list with all addresses defined in any group of addresses: all addresses which are specified on the line. The addresses are Mail::Message::Field::Address objects. example: my @addr = $field->addresses; $obj->attrPairs() See "Access to the content" in Mail::Message::Field::Structured $obj->attribute(OBJECT|(STRING, OPTIONS)|(NAME,VALUE,OPTIONS)) See "Access to the content" in Mail::Message::Field::Structured $obj->attributes() See "Access to the content" in Mail::Message::Field::Structured $obj->beautify() See "Access to the content" in Mail::Message::Field::Full $obj->comment([STRING]) See "Access to the content" in Mail::Message::Field $obj->createComment(STRING, OPTIONS) Mail::Message::Field::Addresses->createComment(STRING, OPTIONS) See "Access to the content" in Mail::Message::Field::Full $obj->createPhrase(STRING, OPTIONS) Mail::Message::Field::Addresses->createPhrase(STRING, OPTIONS) See "Access to the content" in Mail::Message::Field::Full $obj->group(NAME) Returns the group of addresses with the specified NAME, or "undef" if it does not exist. If NAME is "undef", then the default groep is returned. $obj->groupNames() Returns a list with all group names which are defined. $obj->groups() Returns all address groups which are defined in this field. Each element is a Mail::Message::Field::AddrGroup object. $obj->study() See "Access to the content" in Mail::Message::Field $obj->toDate([TIME]) Mail::Message::Field::Addresses->toDate([TIME]) See "Access to the content" in Mail::Message::Field $obj->toInt() See "Access to the content" in Mail::Message::Field Other methods $obj->dateToTimestamp(STRING) Mail::Message::Field::Addresses->dateToTimestamp(STRING) See "Other methods" in Mail::Message::Field Internals $obj->consume(LINE | (NAME,BODY|OBJECTS)) See "Internals" in Mail::Message::Field $obj->decode(STRING, OPTIONS) Mail::Message::Field::Addresses->decode(STRING, OPTIONS) See "Internals" in Mail::Message::Field::Full $obj->defaultWrapLength([LENGTH]) See "Internals" in Mail::Message::Field $obj->encode(STRING, OPTIONS) See "Internals" in Mail::Message::Field::Full $obj->fold(NAME, BODY, [MAXCHARS]) Mail::Message::Field::Addresses->fold(NAME, BODY, [MAXCHARS]) See "Internals" in Mail::Message::Field $obj->setWrapLength([LENGTH]) See "Internals" in Mail::Message::Field $obj->stringifyData(STRING|ARRAY|OBJECTS) See "Internals" in Mail::Message::Field $obj->unfold(STRING) See "Internals" in Mail::Message::Field Parsing $obj->consumeAddress(STRING, OPTIONS) Try to destilate address information from the STRING. Returned are an address object and the left-over string. If no address was found, the first returned value is "undef". $obj->consumeComment(STRING) Mail::Message::Field::Addresses->consumeComment(STRING) See "Parsing" in Mail::Message::Field::Full $obj->consumeDomain(STRING) Try to get a valid domain representation from STRING. Returned are the domain string as found (or "undef") and the rest of the string. $obj->consumeDotAtom(STRING) See "Parsing" in Mail::Message::Field::Full $obj->consumePhrase(STRING) Mail::Message::Field::Addresses->consumePhrase(STRING) See "Parsing" in Mail::Message::Field::Full $obj->datum([VALUE]) See "Parsing" in Mail::Message::Field::Structured $obj->parse(STRING) See "Parsing" in Mail::Message::Field::Full $obj->produceBody() See "Parsing" in Mail::Message::Field::Full Error handling $obj->AUTOLOAD() See "Error handling" in Mail::Reporter $obj->addReport(OBJECT) See "Error handling" in Mail::Reporter $obj->defaultTrace([LEVEL]|[LOGLEVEL, TRACELEVEL]|[LEVEL, CALLBACK]) Mail::Message::Field::Addresses->defaultTrace([LEVEL]|[LOGLEVEL, TRACELEVEL]|[LEVEL, CALLBACK]) See "Error handling" in Mail::Reporter $obj->errors() See "Error handling" in Mail::Reporter $obj->log([LEVEL [,STRINGS]]) Mail::Message::Field::Addresses->log([LEVEL [,STRINGS]]) See "Error handling" in Mail::Reporter $obj->logPriority(LEVEL) Mail::Message::Field::Addresses->logPriority(LEVEL) See "Error handling" in Mail::Reporter $obj->logSettings() See "Error handling" in Mail::Reporter $obj->notImplemented() See "Error handling" in Mail::Reporter $obj->report([LEVEL]) See "Error handling" in Mail::Reporter $obj->reportAll([LEVEL]) See "Error handling" in Mail::Reporter $obj->trace([LEVEL]) See "Error handling" in Mail::Reporter $obj->warnings() See "Error handling" in Mail::Reporter Cleanup $obj->DESTROY() See "Cleanup" in Mail::Reporter $obj->inGlobalDestruction() See "Cleanup" in Mail::Reporter DIAGNOSTICS
Warning: Field content is not numerical: $content The numeric value of a field is requested (for instance the "Lines" or "Content-Length" fields should be numerical), however the data contains weird characters. Warning: Illegal character in charset '$charset' The field is created with an utf8 string which only contains data from the specified character set. However, that character set can never be a valid name because it contains characters which are not permitted. Warning: Illegal character in field name $name A new field is being created which does contain characters not permitted by the RFCs. Using this field in messages may break other e-mail clients or transfer agents, and therefore mutulate or extinguish your message. Warning: Illegal character in language '$lang' The field is created with data which is specified to be in a certain language, however, the name of the language cannot be valid: it contains characters which are not permitted by the RFCs. Warning: Illegal encoding '$encoding', used 'q' The RFCs only permit base64 ("b " or "B ") or quoted-printable ("q" or "Q") encoding. Other than these four options are illegal. Error: No attributes for address fields. Is is not possible to add attributes to address fields: it is not permitted by the RFCs. Error: Package $package does not implement $method. Fatal error: the specific package (or one of its superclasses) does not implement this method where it should. This message means that some other related classes do implement this method however the class at hand does not. Probably you should investigate this and probably inform the author of the package. SEE ALSO
This module is part of Mail-Box distribution version 2.105, built on May 07, 2012. Website: http://perl.overmeer.net/mailbox/ LICENSE
Copyrights 2001-2012 by [Mark Overmeer]. For other contributors see ChangeLog. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See http://www.perl.com/perl/misc/Artistic.html perl v5.14.2 2012-05-07 Mail::Message::Field::Addresses(3pm)
All times are GMT -4. The time now is 02:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy