Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Change just the date format
Top Forums Shell Programming and Scripting Change just the date format Post 302971148 by drl on Saturday 16th of April 2016 09:30:35 AM
Old 04-16-2016
Hi.

Using a utility from the package dateutils, dconv:
Code:
#!/usr/bin/env bash

# @(#) s1       Demonstrate date manipulation, format changes, 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 dateutils.dconv

FILE=${1-data1}

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

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

# 2016-04-15  8.30 -> 15-04-2016  8.30
pl " Results:"
dateutils.dconv -S -i "%F" -f "%d-%m-%Y" < $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 (jessie) 
bash GNU bash 4.3.30
dateutils.dconv dconv 0.3.1

-----
 Input data file data1:
 2016-04-15  8.30 
 2016-04-15  7.30 
 2016-04-13  7.30 
 2016-04-11  8.30 
 2016-04-11  7.30 
 2016-04-08  8.30 
 2016-04-08  7.30 
 2016-04-06  7.30 
 2016-04-04  8.30

-----
 Expected output:
15-04-2016  8.30
15-04-2016  7.30
13-04-2016  7.30
11-04-2016  8.30
11-04-2016  7.30
08-04-2016  8.30
08-04-2016  7.30
06-04-2016  7.30
04-04-2016  8.30

-----
 Results:
 15-04-2016  8.30 
 15-04-2016  7.30 
 13-04-2016  7.30 
 11-04-2016  8.30 
 11-04-2016  7.30 
 08-04-2016  8.30 
 08-04-2016  7.30 
 06-04-2016  7.30 
 04-04-2016  8.30

The dateutils package can be found in repositories Debian, MacOS ("brew"), SuSE, etc., and also at dateutils (verified 2016.04.16)

Best wishes ... cheers, drl
This User Gave Thanks to drl For This Post:
bob123
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to change it to the date format

Hi, I want to know how to change this string to date format 20061102122042 to 02-11-2006 12:20:42 or 02-Nov-2006 12:20:42 Please let me know at the earliest.Thanks in advance. Regards, Preetham R. (3 Replies)
Discussion started by: preethgideon
3 Replies

2. UNIX for Advanced & Expert Users

Change date format

I know the command date +"%Y%m%d" can change today's date to digit format as below . $date +"%Y%m%d" 20071217 it works fine . now I want to do it back . If I have a file like below, (in the file , there are three lines, and each line have ; sign , after the ; sign is the date ) , I... (4 Replies)
Discussion started by: ust
4 Replies

3. Shell Programming and Scripting

How to Change the Format of a Date

Hi All, this is my second post, last post reply was very helpful. I have a data that has date in DD/MM/YYYY (07/11/2008) format i want to replace the backslash by a dot(.) so that my awk script can read it inside the C shell script that i have written. i want to change 07/11/2008 to... (3 Replies)
Discussion started by: asirohi
3 Replies

4. Shell Programming and Scripting

Date Format Change

Hi I have a date format in a variable as Mon Jan 11 03:35:59 2010. how do i change it to YYYYMMDD format (3 Replies)
Discussion started by: keerthan
3 Replies

5. Shell Programming and Scripting

Change date format

Hi guys, I have a text file with lots of lines like this: MCOGT23R27815 27/07/07 27/05/09 SO733AM0235 30/11/07 30/11/10 NL123403N 04/03/08 04/03/11 0747AM7474 04/04/08 04/04/11 I want to change each line so the date format looks like this: MCOGT23R27815 07/07/27 09/05/27 ... (7 Replies)
Discussion started by: Tornado
7 Replies

6. Shell Programming and Scripting

Date Format Change

Hi, Please can I have some command to get yesterday in YYMMDD format? This will be used in ksh Thanks, (2 Replies)
Discussion started by: smalya
2 Replies

7. Shell Programming and Scripting

Date format change

Dear Friends, Need your help once again, I have a variable ( e.g. ${i}) whoch has date in MM/DD/YYYY (E.g. 12/31/2011) format. I want to change it to DD/MM/YYYY (e.g. 31/12/2011) format. Request you to guide me as we are unable to do the same. Thanks in advance Anu. (1 Reply)
Discussion started by: anushree.a
1 Replies

8. Shell Programming and Scripting

change date format

Hi, I have the variable "$date_update" in that form: 2011-12-31T13:00:09Z and I would like to change it to 31/12/2011 13:00:09 (Date and Time separated by a blank). Does anyone has a simple solution for that? (using Korn Shell) Cheers Jurgen (4 Replies)
Discussion started by: jurgen
4 Replies

9. Shell Programming and Scripting

Change the date format

Hi all, I have a file that every line starts with the date and time. The format is like YYYYMMDDHHMM and I woulk like to change it to MM/DD/YY<space>HH:MM. I tried to figure out a way to do it with sed, but I don't know how I could reorganize the digits of the first format. Does anyone have any... (1 Reply)
Discussion started by: geovas
1 Replies

10. Shell Programming and Scripting

Change the date format

Hi, I was looking for a script to change the date from one format to other. A search in the forum gave me the below script as a result. #! /bin/ksh format=YYYYMMDD YEAR=${format%????} DAY=${format#??????} MON=${format#$YEAR} MON=${MON%$DAY} echo $MON/$DAY/$YEAR I got it... (2 Replies)
Discussion started by: prithvirao17
2 Replies

LEARN ABOUT MOJAVE

dp

DP(8)                                                                [nmh-1.5]                                                               DP(8)

NAME

       dp - parse dates 822-style

SYNOPSIS

       /usr/lib/mh/dp [-form formatfile] [-format string] [-width columns] [-version] [-help] dates ...

DESCRIPTION

       Dp  is  a  program that parses dates according to the ARPA Internet standard.  It also understands many non-standard formats, such as those
       produced by TOPS-20 sites and some UNIX sites using ctime(3).  It is useful for seeing how nmh will interpret a date.

       The dp program treats each argument as a single date, and prints the date out in the official 822-format.  Hence, it  is  usually  best  to
       enclose each argument in quotes for the shell.

       To  override  the  output  format  used by dp, the -format string or -format file switches are used.  This permits individual fields of the
       address to be extracted with ease.  The string is simply a format string and the file is simply a format file.  See  mh-format(5)  for  the
       details.

       Here is the default format string used by dp:

            %<(nodate{text})error: %{text}%|%(putstr(pretty{text}))%>

       which  says  that  if an error was detected, print the error, a `:', and the date in error.  Otherwise, output the 822-proper format of the
       date.

FILES

       $HOME/.mh_profile          The user profile

PROFILE COMPONENTS

       None

SEE ALSO

       ap(8), Standard for the Format of ARPA Internet Text Messages (RFC-822)

DEFAULTS

       `-format' default as described above
       `-width' default to the width of the terminal

CONTEXT

       None

BUGS

       The argument to the -format switch must be interpreted as a single token by the shell that invokes dp.  Therefore, one must  usually  place
       the argument to this switch inside quotes.

MH.6.8                                                             11 June 2012                                                              DP(8)
All times are GMT -4. The time now is 11:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy