Date conversion DD-MMM-YY to YYYYMMDD for many columns in a file Post: 302964428

Sponsored Content

Top Forums Shell Programming and Scripting Date conversion DD-MMM-YY to YYYYMMDD for many columns in a file Post 302964428 by drl on Thursday 14th of January 2016 10:45:54 AM

01-14-2016

Registered User

Hi,

Date utility collection dateutils, can handle situations like this. Here's a demonstration, but note that this version of dconv will fail on some 2-digit year data. This is an issue with Debian being behind, the author has added an option to handle many 2-digit years correctly.

Code:

#!/usr/bin/env bash

# @(#) s1	Demonstrate date conversion, dateutils, dconv.
# Warning:
# dateutils earlier than 0.3.3 will not convert correctly some
# 2-digit years by default, as is noted here for year "67".

program=dconv
program=dateutils.dconv
# Utility functions: print-as-echo, print-line-with-visual-space, debug.
# export PATH="/usr/local/bin:/usr/bin:/bin"
LC_ALL=C ; LANG=C ; export LC_ALL LANG
pe() { for _i;do printf "%s" "$_i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
db() { ( printf " db, ";for _i;do printf "%s" "$_i";done;printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && $C $program

FILE=${1-data1}

pl " Input data file $FILE:"
cat $FILE

pl " Expected output:"
cat expected-output.txt

pl " Results:"
input='%d-%b-%y'
pe " Input format is \"$input\""
$program -i "$input" -f '%Y%m%d' -S < $FILE

exit 0

producing:

Code:

$ ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 3.16.0-4-amd64, x86_64
Distribution        : Debian 8.2 (jessie) 
bash GNU bash 4.3.30
dateutils.dconv dconv 0.3.1

-----
 Input data file data1:
Col1|col2|col3|col4|col5|col6-------col26
1|2|3|10-Nov-67|10-Nov-97|4|5-------100
1|2|3|11-Feb-01|01-Dec-15|4|5-------2000

-----
 Expected output:
Col1|col2|col3|col4|col5|col6-------col26
1|2|3|19671110|19971010|4|5-------100
1|2|3|20010211|20151201|4|5-------2000


-----
 Results:
 Input format is "%d-%b-%y"
Col1|col2|col3|col4|col5|col6-------col26
1|2|3|20671110|19971110|4|5-------100
1|2|3|20010211|20151201|4|5-------2000

I hesitated to post code that doesn't work correctly with the user data, but the usefulness of the dateutils collection is appropriate, especially because the issue can be resolved with a more recent version than I have at my disposal.

The collection can be found in many repositories.

Best wishes ... cheers, drl

drl

View Public Profile for drl

Find all posts by drl

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

get yesterday date in yyyymmdd format

I would like to know how I could get a yesterday date in yyyymmdd e.g. today is 20011109, and I would like to get 20011108. Thank you!:confused:

2. HP-UX

How can i get the yesterday's date in YYYYMMDD format

How can i get the yesterday's date in YYYYMMDD format???

3. Shell Programming and Scripting

Using awk to convert DD-MMM-YY to YYYYMMDD

Hi i need to convert a date in the format DD-Mon-YY to YYYYDDMM Ex : 01-JUL-00 to 20000701 Can anybdy help me with this?? Thanks in advance Shenaz

4. 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. Shell Programming and Scripting

Date string conversion within a file

Hi, I have a log file that contains information along the lines of the following: ========= jobnumber 322761 start_time Tue May 19 19:42:37 2009 end_time Tue May 19 20:11:28 2009 failed 0 ========= jobnumber 322762 start_time Tue May 19 19:39:51 2009 end_time ...

6. Solaris

Date after 5 dates in YYYYMMDD format

Hi Experts, How to get date 5 days after current date in YYYYMMDD format? How do we compare date in YYYYMMDD format? Thanks

7. Shell Programming and Scripting

Date after 5 days from current date in YYYYMMDD format

Hello Experts, How do i get date after 5 days from current date in YYYYMMDD format? How do you compare date in YYYYMMDD format? Thanks

8. Shell Programming and Scripting

Find first created file date in YYYYMMDD format

Hi All, We are copying all the files into ARCHIVE directory after we process them. We are doing this process from last 2 years, now we have a lot of files in ARCHIVE directory. Now I need to find when the first file is copied into this directory? If I Issue, ls -l /ARCHIVE/*.* | tail -1...

9. Shell Programming and Scripting

perl one-liner to get yesterday's date in format dd-MMM-yy (i.e. 01-JAN-12)

I have the following perl one-liner to get yesterday's date, but I would like it in the form of dd-MMM-yy (for example: 01-JAN-12). Can someone alter the below code so I get the format I want? Also, could someone also give me a line for dd-Mmm-yy (for example 01-Jan-12)? Code: YEST=`perl -w...

10. Shell Programming and Scripting

Date format to be changed from DDMMYYYY to YYYYMMDD

My requirement is:- there will be files at a location each day with the date format DDMMYYYY. Novawise_Activity_Call_Notes_04022013.txt Novawise_Activity_Inbound_04022013.txt Novawise_Activity_Inbound_05022013.txt Novawise_Activity_Call_Notes_05022013.txt...

LEARN ABOUT SUNOS

env

env(1)								   User Commands							    env(1)

NAME

       env - set environment for command invocation

SYNOPSIS

       /usr/bin/env [-i | -]  [name=value...] [ utility [ arg... ]]

       /usr/xpg4/bin/env [-i | -]  [name=value...] [ utility [ arg... ]]

DESCRIPTION

       The  env utility obtains the current environment, modifies it according to its arguments, then invokes the utility named by the utility op-
       erand with the modified environment.

       Optional arguments are passed to utility. If no utility operand is specified, the resulting environment is written to the standard  output,
       with one name=value pair per line.

   /usr/bin
       If env executes commands with arguments, it uses the default shell /usr/bin/sh (see sh(1)).

   /usr/xpg4/bin
       If env executes commands with arguments, it uses /usr/xpg4/bin/sh (see ksh(1)).

OPTIONS

       The following options are supported:

       -i | -	       Ignores the environment that would otherwise be inherited from the current shell.  Restricts the environment for utility to
		       that specified by the arguments.

OPERANDS

       The following operands are supported:

       name=value      Arguments of the form name=value modify the execution environment, and are placed into  the  inherited  environment  before
		       utility is invoked.

       utility	       The name of the utility to be invoked.  If utility names any of the special shell built-in utilities, the results are unde-
		       fined.

       arg	       A string to pass as an argument for the invoked utility.

EXAMPLES

       Example 1: Invoking utilities with new PATH values

       The following utility:

       example% env -i PATH=/mybin mygrep xyz myfile

       invokes the utility mygrep with a new PATH value as the only entry in its environment. In this case, PATH is used to locate  mygrep,  which
       then must reside in /mybin.

ENVIRONMENT VARIABLES

       See  environ(5)	for  descriptions of the following environment variables that affect the execution of env: LANG, LC_ALL, LC_CTYPE, LC_MES-
       SAGES, and NLSPATH.

       PATH	Determine the location of the utility. If PATH is specified as a name=value operand to env, the value given shall be used  in  the
		search for utility.

EXIT STATUS

       If  utility  is invoked, the exit status of env is the exit status of utility. Otherwise, the env utility returns one of the following exit
       values:

       0	Successful completion.

       1-125	An error occurred.

       126	utility was found but could not be invoked.

       127	utility could not be found.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

   /usr/bin
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |enabled			   |
       +-----------------------------+-----------------------------+

   /usr/xpg4/bin
       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWxcu4			   |
       +-----------------------------+-----------------------------+
       |CSI			     |enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       ksh(1), sh(1), exec(2), profile(4), attributes(5), environ(5), standards(5)

SunOS 5.10							    2 Jan 2002								    env(1)