Sponsored Content
Top Forums Shell Programming and Scripting Pattern to match date in YYYY-MM-DD format on Linux machine Post 303010724 by Don Cragun on Saturday 6th of January 2018 02:58:29 AM
Old 01-06-2018
Quote:
Originally Posted by as7951
Hi Don,

Yes this is the problem,
date is present in correct format 2017-11-03 in column but still getting the below error message.
Code:
Error 131: Incorrect DocumentDate pattern Field position 14, Linenumber:2

However error is supposed to appear when column value is empty or date is present in wrong format like this(17-11-03 or 2017-1-03, etc).
No! If that is the diagnostic message you're getting, the line that is being processed is a blank line. Note that the code that prints that message displays $0 (i.e., the entire contents of that record) at the end of the output produced by that awk print statement. So, $14 (and every other field in that record) is an empty field and you get the diagnostic message you showed us.
 

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
show(1mh)																 show(1mh)

Name
       show - show (list) messages

Syntax
       show [ +folder ] [ msgs ] [ -draft ] [ -[no]header ] [ -help ] [ -showproc program ] [ -noshowproc ] [ options to ]

Description
       Use  to	display  the  contents of the current message.	You can specify alternative messages or folders by using the +folder or msgs argu-
       ments.

       If a folder is given, it becomes the current folder.  The last message shown becomes the current message.

       You can specify a number of messages or a range of messages using the msgs argument.  If you specify more than one message, prompts  for  a
       <RETURN> prior to listing each message.

       Typically,  the	messages  are  listed exactly as they are, with no reformatting.  A program named by the showproc component in the file is
       invoked to do the listing, and any options not recognized by are passed along to that program.  The default program is

       By default, the command use the program to list each message, a page at a time.	When the end of the  page  is  reached,  it  waits  for  a
       <RETURN>  or a space.  If you press <RETURN>, prints the next line.  If you press the space bar, it prints the next screen of data.  At the
       end of the message, automatically returns you to the system prompt.  Press q to quit before the end of the message.

       If the profile entry Unseen-Sequence: is present and non-empty, then will remove each of the messages shown from the sequences named by the
       profile entry.

Options
       -draft	 Displays  the draft message, or the current message in your folder, if you have one set up.  You cannot give a msgs argument when
		 you use this option.

       -header
       -noheader Displays a one-line header before the message.  The header consists of the name of the folder and the message	number.   This	is
		 the default behavior.	It can be suppressed with the -noheader option.

       -help	 Prints a list of the valid options to this command.

       -showproc program [ options ]
       -noshowproc
		 Specifies an alternative program to list messages.  The default is to use the program defined by the showproc: entry in the file.
		 You can give options to the program at the command line.  These are passed directly to by

		 If the -noshowproc option is specified, is used instead of

		 The MH command can be used as a to show messages in a more uniform format.  See for more details.

		 If you are going to use the same all the time, it is advisable to specify it in your file.  See for more details.

       The defaults for this command are as follows:

	      +folder defaults to the current folder
	      msgs defaults to the current message
	      -header

Restrictions
       The -header option does not work when expands to more than one message.	If the is then this problem can be circumvented by referencing the
       messagename field in the format file.

       The  command updates your mail environment before showing the message.  Hence may mark messages as seen before you actually see them.  How-
       ever, this is generally not a problem, unless you are using the unseen messages mechanism, and you interrupt while  it  is  showing  unseen
       messages.

       If your is then uses a built-in it does not actually run the program.  Hence, if you define your own do not call it since will not run it.

       If is your (which is the default), then avoid running in the background with only its standard output piped to another process.	You should
       re-direct the diagnostic output of as well.

       For example, in the following incorrect example, will go into a input state:
       % show | print &
       For users of the correct command is:
       % show |& print &
       For users of the correct command is:
       % show 2>&1 | print &

Examples
       In the first example, displays the contents of message 36 in the current folder:
       % show 36

       In the next example, the program is used to list the current message:
       % show -showproc pr

Profile Components
       Path:		  To determine the user's Mail directory
       Unseen-Sequence:   To name sequences denoting unseen messages
       showproc:	  Program to show messages

Files
       The user profile.

See Also
       more(1), mhl(1mh), next(1mh), pick(1mh), prev(1mh), scan(1mh)

																	 show(1mh)
All times are GMT -4. The time now is 09:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy