|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Convert the date format from mdy to ymd in column of file
Post 302541650 by rangarasan on Monday 25th of July 2011 09:04:08 AM
07-25-2011
change date format
Quote:
Try this one,
Code:
nawk 'BEGIN{FS=" ";ORS=" ";}{split($2,a,"/");for(i=1;i<=NF;i++){if ( i == 2){print a[3]"/"a[2]"/"a[1];}else{print $i;}}print "\n"}' input_file$2=DateField
Input Sample:
Code:
SomeInfo 6/27/2011 12:00:00 AM SomeInfo 6/27/2011 12:00:00 AM
Code:
SomeInfo 2011/27/6 12:00:00 AM SomeInfo 2011/27/6 12:00:00 AM
Ranga
Last edited by radoulov; 07-25-2011 at 10:44 AM.. Reason: Code tags.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
for reading a cobol indexed file i need to convert "mmddyy" date format to "ccyyddd" format.
i checked the datecalc and other scripts but couldnt modify them to cater to my need:(...
The datecalc gives an output which i believe is the total days till that date, but i want to convert it... (2 Replies)
Discussion started by: Bhups
2 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
Need your help in converting a date format in ksh.
I'm currently working on SUN os where my script is getting a date from a table.
The result returns to ksh in this format: 17-JUL-08
How do i convert this string to a date format like yyyymmdd?
I tried #!/bin/ksh
d="17-JUL-08"... (5 Replies)
Discussion started by: agathaeleanor
5 Replies
3. Shell Programming and Scripting
I have a file named "suspected" with series of line like these :
{'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''}
{'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies
4. Shell Programming and Scripting
I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column.
I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this?
Sample input
02/27/09,23:52:31
02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies
5. Shell Programming and Scripting
I am trying to generate a report with below file :
File1 :
EQADM,edrtere9-phys,8122caef0,gpatmon,/bin/ksh,nuten Erick
EQADM,edrtere11-phys,8227caef0,gpatmon,/bin/ksh,nuten Erick
EQADM,edrtere3-phys,822caef0,gpatmon,/bin/ksh,nuten Erick
can you help me convert it to html and add... (9 Replies)
Discussion started by: sriram003
9 Replies
6. Shell Programming and Scripting
I've been using this thread:
https://www.unix.com/shell-programming-scripting/58675-change-date-dd-mmm-yyyy-mm-dd-yyyy.html
and
https://www.unix.com/shell-programming-scripting/14655-changing-yyyy-mm-dd-ddmmyy.html
and this code:
on this format:
05/16/2008 18:30:49 Installation 48985and I'm... (3 Replies)
Discussion started by: dba_frog
3 Replies
7. Shell Programming and Scripting
The 6th & 7th column of the text files represents date & time. I need this to be converted in julian format using command "date +%s -d <date>". I know the command, but dont know how to use it on the script
0 dbclstr-b IXT_Web Memphis_Prod_SQL_Full Memphis-Prod-SQL-Full-Application-Backup... (4 Replies)
Discussion started by: ajiwww
4 Replies
8. Shell Programming and Scripting
Hi All,
I have file like
“April 10, 2013”,”raj”
“April 29, 2013”,”raj1”
Output :
“2013/04/10”,”raj”
“2013/04/29”,”raj1”
Please help me how to do... (9 Replies)
Discussion started by: bmk
9 Replies
9. Shell Programming and Scripting
Hi,
i have a flat file namely temp.txt with this data below
ID|name|contact_date
101|Kay|2013-12-26
102|let|2013-12-26
I need to modify the date data in the flat file into MM/DD/YYYY HH24:MI:SS format
let me know the code for this.
Thank you! (5 Replies)
Discussion started by: srikanth_sagi
5 Replies
10. Shell Programming and Scripting
Hello,
I want to change the format of date value in variable.
e.g. cur_date = '2013/03/13 14:24:50' (yyyy/mm/dd hh24:mi:ss)
I want to change this to '13-MAR-2013 14:24:50
Following code coverts the current date to format I am looking for. But I do not know how this can be done for a date... (8 Replies)
Discussion started by: cartrider
8 Replies
LEARN ABOUT CENTOS
grub-render-label
GRUB-RENDER-LABEL(1) User Commands GRUB-RENDER-LABEL(1) NAME
grub-render-label - generate a .disk_label for Apple Macs. SYNOPSIS
grub-render-label [OPTION...] [OPTIONS] DESCRIPTION
Render Apple .disk_label. -b, --bgcolor=COLOR use COLOR for background -c, --color=COLOR use COLOR for text -f, --font=FILE use FILE as font (PF2). -i, --input=FILE read text from FILE. -o, --output=FILE set output filename. Default is STDOUT -t, --text=STRING set the label to render -v, --verbose print verbose messages. -?, --help give this help list --usage give a short usage message -V, --version print program version Mandatory or optional arguments to long options are also mandatory or optional for any corresponding short options. REPORTING BUGS
Report bugs to <bug-grub@gnu.org>. SEE ALSO
The full documentation for grub-render-label is maintained as a Texinfo manual. If the info and grub-render-label programs are properly installed at your site, the command info grub-render-label should give you access to the complete manual. grub-render-label (GRUB) 2.02-2ubuntu8.3 July 2018 GRUB-RENDER-LABEL(1)