Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert DD-MMM-YYYY to MM-DD-YYYY
Top Forums Shell Programming and Scripting Convert DD-MMM-YYYY to MM-DD-YYYY Post 302304459 by nuthalapati on Monday 6th of April 2009 01:33:19 PM
Old 04-06-2009
Convert DD-MMM-YYYY to MM-DD-YYYY
I have a file which has 100k+ records like this

Code:










Code:



abc,05-JUN-1974,def,lkj,aaa
def,11-SEP-1975,ghj,dis,dea









 

I want to convert ex 05-JUN-1974 to 06/05/1974

 

Please help me with awk script to convert the whole file into MM-DD-YYYY

 

Thank you!







        

        

       



            
            
            
            


            

            
            




            
                
            

            

        



        


        


 


        

        
        

        


 

            
        




















	


		


		 
		
			












	
	









    







10 More Discussions You Might Find Interesting











1. Shell Programming and Scripting






 Change Date from dd-mmm-yyyy to mm/dd/yyyy




I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks (9 Replies)





Discussion started by: stringzz



9 Replies








2. Shell Programming and Scripting






 converting the date field from dd/mm/yyyy to yyyy/mm/dd




How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix 
my script will generate text file which have two fields  
one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will... (4 Replies)





Discussion started by: pareshan



4 Replies








3. Shell Programming and Scripting






 Sed: zero-padding dates (or: convert d/m/yyyy to dd/mm/yyyy)




Hi all 
 
I have some pipe-separated data in the form: 
 
5/12/2008 00:00:00|31/1/2009 00:00:00|SOMESTUFF|OTHERSTUFF 
12/31/2008 00:00:00|15/1/2009 00:00:00|MORESTUFF|REMAININGSTUFF 
1/1/1023  00:00:00|16/5/2047 00:00:00|THEREST|YETMORE 
 
I need to zero-pad the single-digit days and months, using... (3 Replies)





Discussion started by: jgrogan



3 Replies








4. Shell Programming and Scripting






 convert d/m/yyyy to YYYY-MM-DD




My csv has data like this 
  
x,x,3452,2/18/1986,abc 
x,g,19711,1/24/1986,abc 
  
i want to replace date in the following format YYYY-mm-dd  
  
how do i convert using awk script ? (8 Replies)





Discussion started by: nuthalapati



8 Replies








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








6. Shell Programming and Scripting






 Converting date DD MM YYYY to DD MON YYYY




Hello, 
  
I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10) 
To extract the dates, I am using shell substrings, i.e.: 
  
 
read line 
 ... (4 Replies)





Discussion started by: Adamm



4 Replies








7. UNIX for Dummies Questions & Answers






 Epoch date to YYYY/MM/DD or MM/DD/YYYY




I've seen a lot of posts on this and have tried the following: 
 
 echo 1257000000| perl -e '($d,$m,$y)=(localtime(time-86400));$m+=1;$y+=1900;printf "$y/$m/$d\n";'  
 
But I am unable to convert a past Epoch date into a format such as YYYY/MM/DD or MM/DD/YYYY.   
 
I am using bash and don't know... (4 Replies)





Discussion started by: newbie2010



4 Replies








8. Shell Programming and Scripting






 Bash to convert to m-d-yyyy




I am using bash that when run downloads a file a verifies that there is data in it. What I am not able to do is have a user enter a date in any format they wish and have it converted to m-d-yyyy.  Thank you :). 
 
Bash 
 
printf " Welcome to NGS analysis, checking for new files and creating a... (2 Replies)





Discussion started by: cmccabe



2 Replies








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








10. UNIX for Advanced & Expert Users






 How to convert mmm-yy to mm/dd/yyyy format in UNIX ?




How to convert mmm-yy to mm/dd/yyyy format in unix ? 
 
example: 
 
Jan-99 to 01/01/1999 
Jan-00 to 01/01/2000 
Jan-25 to 01/01/2025 
 
Dec-99 to 01/12/1999 
Dec-00 to 01/12/2000 
Dec-25 to 01/12/2025 
 
YY anything between 00-50 should be 2000-2050 
YY anything between 51-99 should be 1951-1999 
... (2 Replies)





Discussion started by: gksenthilkumar



2 Replies












    

       

          
        

    

    

      

          
        

    













LEARN ABOUT DEBIAN



stg-import








STG-IMPORT(1)							   StGit Manual 						     STG-IMPORT(1)

NAME

       stg-import - Import a GNU diff file as a new patch

SYNOPSIS

       stg import [options] [<file>|<url>]

DESCRIPTION

       Create a new patch and apply the given GNU diff file (or the standard input). By default, the file name is used as the patch name but this
       can be overridden with the --name option. The patch can either be a normal file with the description at the top or it can have standard
       mail format, the Subject, From and Date headers being used for generating the patch information. The command can also read series and mbox
       files.

       If a patch does not apply cleanly, the failed diff is written to the .stgit-failed.patch file and an empty StGIT patch is added to the
       stack.

       The patch description has to be separated from the data with a --- line.

OPTIONS

       -m, --mail
	   Import the patch from a standard e-mail file.

       -M, --mbox
	   Import a series of patches from an mbox file.

       -s, --series
	   Import a series of patches from a series file or a tar archive.

       -u, --url
	   Import a patch from a URL.

       -n NAME, --name NAME
	   Use NAME as the patch name.

       -p N, --strip N
	   Remove N leading slashes from diff paths (default 1).

       -t, --stripname
	   Strip numbering and extension from patch name.

       -i, --ignore
	   Ignore the applied patches in the series.

       --replace
	   Replace the unapplied patches in the series.

       -b BASE, --base BASE
	   Use BASE instead of HEAD for file importing.

       --reject
	   Leave the rejected hunks in corresponding *.rej files.

       -e, --edit
	   Invoke an editor for the patch description.

       -d, --showdiff
	   Show the patch content in the editor buffer.

       -a "NAME <EMAIL>", --author "NAME <EMAIL>"
	   Use "NAME <EMAIL>" as the author details.

       --authname AUTHNAME
	   Use AUTHNAME as the author name.

       --authemail AUTHEMAIL
	   Use AUTHEMAIL as the author e-mail.

       --authdate AUTHDATE
	   Use AUTHDATE as the author date.

       --sign
	   Add a "Signed-off-by:" to the end of the patch.

       --ack
	   Add an "Acked-by:" line to the end of the patch.

STGIT

       Part of the StGit suite - see linkman:stg[1]

StGit								    03/13/2012							     STG-IMPORT(1)





















All times are GMT -4. The time now is 05:45 AM.









	






















	
	

Unix & Linux Forums Content Copyright  1993-2022. All Rights Reserved. 

        



Privacy Policy