Date format to be changed from DDMMYYYY to YYYYMMDD Post: 302779021

Sponsored Content

Top Forums Shell Programming and Scripting Date format to be changed from DDMMYYYY to YYYYMMDD Post 302779021 by djrulz123 on Tuesday 12th of March 2013 03:57:22 AM

03-12-2013

Registered User

in order to find out the date of the files i have used the below code

ls|rev|cut -d "." -f2|cut -d "_" -f1|rev

this gives me the dates of all the files in the format ddmmyyyy.

now if i can change this to YYYYMMDD then my problem is solved. I would be able to bring the files which have this above calculated date greater than the last run date.
can this be done??

---------- Post updated at 01:27 PM ---------- Previous update was at 01:17 PM ----------

if the date can be changed to YYYYMMDD then i can use the code below to bring the relative files.

Code:

set -vx
TARGET_DIR=$2
SOURCE_DIR=$1
LOGDIR=/info_d05/visage/SrcFiles/IQAlign/Log_Files
b=`cat $LOGDIR/last_date.txt`
for i in $SOURCE_DIR/Novawise*
do
 fname=`basename $i`
 p=`echo $fname|rev|cut -d "." -f2|cut -d "_" -f1|rev|something`
  if [ $p -gt $b ]
  then
   cp $SOURCE_DIR/$fname $TARGET_DIR/
  fi
  
done

the something part needs to be completed...

Last edited by radoulov; 03-12-2013 at 07:17 AM.. Reason: Code tags fixed.

djrulz123

View Public Profile for djrulz123

Find all posts by djrulz123

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

Convert filenames with DDMMYYYY to YYYYMMDD

Okay, I have posted on here one other time and received very fast help, so I figured I'd post again. Searched for awhile and couldn't find exactly what I'm looking for. I am attempting to write a script that will search through a given directory, or search through the current directory, and...

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

convert date format YYYYMMDD to MM/DD/YYYY

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks.

6. Shell Programming and Scripting

Change the date format from mmddyyyy to yyyymmdd

How do I change the date format from mmddyyyy to yyyymmdd in PERL. Can any one help me please.

7. 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

8. 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

9. Shell Programming and Scripting

Validating date in yyyymmdd format using PERL

Hi all, i had a code where in user will enter a date in yyyymmdd format.. i didnt use any validation for the date and now the problem is if a user enters date instead of month after year it is proceeding with the code.. like if the date is 20120426 and if the user enters 20122604 it...

10. Shell Programming and Scripting

Command to check date format DDMMYYYY

LEARN ABOUT OPENSOLARIS

rev

rev(1)								   User Commands							    rev(1)

NAME

       rev - reverse the characters or lines of one or more files

SYNOPSIS

       /usr/bin/rev [-l] [file ...]

DESCRIPTION

       rev copies one or more files to standard output, reversing the order of characters on every line of the file.

OPTIONS

       The following options are supported:

       -l	 Reverse the order of the lines of the file, instead of characters.
       --line

OPERANDS

       The following operands are supported:

       file    Specifies the name of the file to use as input.

	       If file is not specified, or if file is a -, rev copies from standard input starting at the current offset.

EXIT STATUS

       The following exit values are returned:

       0     All files copied successfully.

       >0    One or more files did not copy.

ATTRIBUTES

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       cat(1), ksh93(1)tail(1), attributes(5)

SunOS 5.11							    27 Jan 2009 							    rev(1)