Sponsored Content
Full Discussion: Date Reformatting function
Top Forums Shell Programming and Scripting Date Reformatting function Post 302914347 by RudiC on Monday 25th of August 2014 06:47:45 AM
Old 08-25-2014
Try this (assuming you want it done in shell script), which is just juggling chars, not doing any validity checking etc., nor month name conversions:
Code:
fn_date_reformatter() {
                IDXD=${2%%D*}
                IDXM=${2%%M*}
                IDXY=${2%%Y*}
                echo ${1:${#IDXY}:4}${1:${#IDXM}:2}${1:${#IDXD}:2}    
                }
fn_date_reformatter '20140801' 'YYYYMMDD'
20140801
fn_date_reformatter '01-08-2014' 'DD-MM-YYYY'
20140801
fn_date_reformatter '01082014' 'DDMMYYYY'
20140801
fn_date_reformatter '2014-08-01' 'YYYY-MM-DD'
20140801

---------- Post updated at 12:47 ---------- Previous update was at 12:00 ----------

Try this with month name conversion:
Code:
fn_date_reformatter() {
        M=JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC
        IXO="${2%%MON*}"
        IXD="${2%%DD*}"
        IXM="${2%%MM*}"
        IXY="${2%%YY*}"
        printf "%s" ${1:${#IXY}:4}
        [ "${IXO}" != "$2" ] &&
             { L="${M%${1:${#IXO}:3}*}"
              printf "%02d" $((${#L}/3+1))
            } ||
              printf "%s" ${1:${#IXM}:2}
        printf "%s\n" ${1:${#IXD}:2}
        }
fn_date_reformatter '01-AUG-2014' 'DD-MON-YYYY'
20140801
fn_date_reformatter 'AUG-01-2014' 'MON-DD-YYYY'
20140801

(Looks a bit clumsy with all those abbreviated variable names...)
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Date function question

hi guys! just want to ask if you could help me with the sript i'm working on. i need to automatically generate a summarized report everyday for all transactions the day before and ftp it to another machine. my only problem is that i need to name the file as the date yesterday. for example if i... (12 Replies)
Discussion started by: crpalermo
12 Replies

2. UNIX for Dummies Questions & Answers

Yesterday's date function

I am using this function to calculate yesterday's date and return it in the following format: Jan 09 date '+%b %d %Y' | { read MONTH DAY YEAR DAY=`expr "$DAY" - 1` case "$DAY" in 0) MONTH=`expr "$MONTH" - 1` case "$MONTH" in ... (4 Replies)
Discussion started by: ssmiths001
4 Replies

3. Shell Programming and Scripting

date function

hi, I have to ftp previous days file from a directory to another location. The name of the files are like "xxx20060225" (yyyymmdd format) "xxx20060226" ls -lrt xxx*| tail -2| head -1 will give me the file, but if i could get anything... (2 Replies)
Discussion started by: abey
2 Replies

4. Shell Programming and Scripting

Wrong date function

Hi, I am getting some very strange output when using date function in PERL on Solaris. Infact the month portion is wrong and it is 1 less then the current, means today it is responding as month =3 , andthis should be 4 ------> April Any help my code is ($day, $month, $year) =... (3 Replies)
Discussion started by: Asteroid
3 Replies

5. Shell Programming and Scripting

Date Function

Hi, My file format is: E102,0,21-04-2007,0,2/25/1994,E003,A,125400,10450,60.2884620 E103,0,21/04/2007,0,2/2/1996,E003,A,125400,10450,60.2884620 E104,0,04/21/2007,0,2/2/1996,E003,A,125400,10450,60.2884620 E105,0,21-APR-2007,0,2/2/1996,E003,A,125400,10450,60.2884620... (1 Reply)
Discussion started by: charandevu
1 Replies

6. Shell Programming and Scripting

Date Function

Hi, My file format is: E102,0,21-04-2007,0,2/25/1994,E003,A,125400,10450,60.2884620 E103,0,21/04/2007,0,2/2/1996,E003,A,125400,10450,60.2884620 E104,0,04/21/2007,0,2/2/1996,E003,A,125400,10450,60.2884620 E105,0,21-APR-2007,0,2/2/1996,E003,A,125400,10450,60.2884620... (1 Reply)
Discussion started by: charandevu
1 Replies

7. Shell Programming and Scripting

Date function

I read man page for etc/shadow field.. on the 8th field, i assume that's the field to change account expire date. my question is: What value does the 8th field keep? i assume it's 13514 instead of "Date" value such as 11/10/08. on the man page, it said: " expire value = 13514 = jan 1,... (11 Replies)
Discussion started by: c00kie88
11 Replies

8. UNIX for Dummies Questions & Answers

Date reformatting

I currently have the following file containing sample values for a number of dates: Loc1 04 Jan 2007 0.95 0.9532 Loc1 05 Jan 2007 0.95 0.9513 Loc1 06 Jan 2007 0.95 0.9535 This continues for all months of the year and spans across several years. I am trying to reformat the dates so that... (2 Replies)
Discussion started by: figaro
2 Replies

9. UNIX for Dummies Questions & Answers

Date reformatting

I have a file with temperature measurements: Loc1,20090102,71.55 Loc1,20090103,71.65 Loc1,20090104,71.55 Loc1,20090105,71.54 Loc1,20090106,71.54 However, to load this into a database I would like to reformat the dates (column 2) from the yyyymmdd format to the yyyy-mm-dd format. I have... (2 Replies)
Discussion started by: figaro
2 Replies

10. UNIX for Dummies Questions & Answers

Date reformatting

I have been reformatting dates from a data file to make them mysql compliant. 31-10-2011 Loc1 1-11-2011 Loc2 The first can be captured by this: sed -i '' -e "s#\(..\)-\(..\)-\(....\)#\3-\2-\1#" data.txt and leads to: 2011-10-31 Loc1 The second line is captured as follows: sed -i... (2 Replies)
Discussion started by: figaro
2 Replies
GETDATE(3)						     Linux Programmer's Manual							GETDATE(3)

NAME
getdate, getdate_r - convert a date-plus-time string to broken-down time SYNOPSIS
#include <time.h> struct tm *getdate(const char *string); extern int getdate_err; #include <time.h> int getdate_r(const char *string, struct tm *res); Feature Test Macro Requirements for glibc (see feature_test_macros(7)): getdate(): _XOPEN_SOURCE >= 500 || _XOPEN_SOURCE && _XOPEN_SOURCE_EXTENDED getdate_r(): _GNU_SOURCE DESCRIPTION
The function getdate() converts a string representation of a date and time, contained in the buffer pointed to by string, into a broken- down time. The broken-down time is stored in a tm structure, and a pointer to this structure is returned as the function result. This tm structure is allocated in static storage, and consequently it will be overwritten by further calls to getdate(). In contrast to strptime(3), (which has a format argument), getdate() uses the formats found in the file whose full pathname is given in the environment variable DATEMSK. The first line in the file that matches the given input string is used for the conversion. The matching is done case insensitively. Superfluous whitespace, either in the pattern or in the string to be converted, is ignored. The conversion specifications that a pattern can contain are those given for strptime(3). One more conversion specification is specified in POSIX.1-2001: %Z Timezone name. This is not implemented in glibc. When %Z is given, the structure containing the broken-down time is initialized with values corresponding to the current time in the given timezone. Otherwise, the structure is initialized to the broken-down time corresponding to the current local time (as by a call to local- time(3)). When only the weekday is given, the day is taken to be the first such day on or after today. When only the month is given (and no year), the month is taken to be the first such month equal to or after the current month. If no day is given, it is the first day of the month. When no hour, minute and second are given, the current hour, minute and second are taken. If no date is given, but we know the hour, then that hour is taken to be the first such hour equal to or after the current hour. getdate_r() is a GNU extension that provides a reentrant version of getdate(). Rather than using a global variable to report errors and a static buffer to return the broken down time, it returns errors via the function result value, and returns the resulting broken-down time in the caller-allocated buffer pointed to by the argument res. RETURN VALUE
When successful, getdate() returns a pointer to a struct tm. Otherwise, it returns NULL and sets the global variable getdate_err to one of the error numbers shown below. Changes to errno are unspecified. On success getdate_r() returns 0; on error it returns one of the error numbers shown below. ERRORS
The following errors are returned via getdate_err (for getdate()) or as the function result (for getdate_r()): 1 The DATEMSK environment variable is not defined, or its value is an empty string. 2 The template file specified by DATEMSK cannot be opened for reading. 3 Failed to get file status information. 4 The template file is not a regular file. 5 An error was encountered while reading the template file. 6 Memory allocation failed (not enough memory available). 7 There is no line in the file that matches the input. 8 Invalid input specification. ENVIRONMENT
DATEMSK File containing format patterns. TZ, LC_TIME Variables used by strptime(3). ATTRIBUTES
Multithreading (see pthreads(7)) The getdate() function is not thread-safe. The getdate_r() function is thread-safe. CONFORMING TO
POSIX.1-2001. NOTES
The POSIX.1-2001 specification for strptime(3) contains conversion specifications using the %E or %O modifier, while such specifications are not given for getdate(). In glibc, getdate() is implemented using strptime(3), so that precisely the same conversions are supported by both. EXAMPLE
The program below calls getdate() for each of its command-line arguments, and for each call displays the values in the fields of the returned tm structure. The following shell session demonstrates the operation of the program: $ TFILE=$PWD/tfile $ echo '%A' > $TFILE # Full weekday name $ echo '%T' >> $TFILE # ISO date (YYYY-MM-DD) $ echo '%F' >> $TFILE # Time (HH:MM:SS) $ date $ export DATEMSK=$TFILE $ ./a.out Tuesday '2009-12-28' '12:22:33' Sun Sep 7 06:03:36 CEST 2008 Call 1 ("Tuesday") succeeded: tm_sec = 36 tm_min = 3 tm_hour = 6 tm_mday = 9 tm_mon = 8 tm_year = 108 tm_wday = 2 tm_yday = 252 tm_isdst = 1 Call 2 ("2009-12-28") succeeded: tm_sec = 36 tm_min = 3 tm_hour = 6 tm_mday = 28 tm_mon = 11 tm_year = 109 tm_wday = 1 tm_yday = 361 tm_isdst = 0 Call 3 ("12:22:33") succeeded: tm_sec = 33 tm_min = 22 tm_hour = 12 tm_mday = 7 tm_mon = 8 tm_year = 108 tm_wday = 0 tm_yday = 250 tm_isdst = 1 Program source #define _GNU_SOURCE 500 #include <time.h> #include <stdio.h> #include <stdlib.h> int main(int argc, char *argv[]) { struct tm *tmp; int j; for (j = 1; j < argc; j++) { tmp = getdate(argv[j]); if (tmp == NULL) { printf("Call %d failed; getdate_err = %d ", j, getdate_err); continue; } printf("Call %d ("%s") succeeded: ", j, argv[j]); printf(" tm_sec = %d ", tmp->tm_sec); printf(" tm_min = %d ", tmp->tm_min); printf(" tm_hour = %d ", tmp->tm_hour); printf(" tm_mday = %d ", tmp->tm_mday); printf(" tm_mon = %d ", tmp->tm_mon); printf(" tm_year = %d ", tmp->tm_year); printf(" tm_wday = %d ", tmp->tm_wday); printf(" tm_yday = %d ", tmp->tm_yday); printf(" tm_isdst = %d ", tmp->tm_isdst); } exit(EXIT_SUCCESS); } SEE ALSO
time(2), localtime(3), setlocale(3), strftime(3), strptime(3) COLOPHON
This page is part of release 3.53 of the Linux man-pages project. A description of the project, and information about reporting bugs, can be found at http://www.kernel.org/doc/man-pages/. 2013-06-21 GETDATE(3)
All times are GMT -4. The time now is 01:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy