Sponsored Content
Top Forums Shell Programming and Scripting Date format change in a csv file Post 302948960 by Aia on Sunday 5th of July 2015 02:10:35 AM
Old 07-05-2015
Quote:
Originally Posted by cfajohnson
[..]
Code:
IFS=/ read month day year whatever <<.
$yourolddateformat
.

Or, in bash or ksh93:
Code:
IFS=/ read month day year whatever <<< "$yourolddateformat"

[...]
Since the `/' is used as separator, the string can be only divided into three parts, making whatever useless, or in other words, there's no whatever; the year will receive the time as well.
Perhaps a minor modification.
Code:
IFS='/ ' read month day year time <<.
> $yourolddateformat
> .


Last edited by Aia; 07-05-2015 at 03:22 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script to change the date format in a file

i have many files with date format of 6-9-2008 and i want a script that can change the format to 2008-06-09 Thanks (15 Replies)
Discussion started by: shehzad_m
15 Replies

2. Shell Programming and Scripting

Format a date in a csv file

So I have a csv file where the 3rd field is a date string in the format yyyy-mm-dd. I need to change it to mm/dd/yyyy. So each line in the csv file looks like: StringData,StringData,2009-02-17,12.345,StringData StringData,StringData,2009-02-16,65.789,StringData Any idea how I can keep... (5 Replies)
Discussion started by: rpiller
5 Replies

3. Shell Programming and Scripting

How to change date format in file

Hello! I have a textfile that look like this: "83d1:46:2b";"20091008190000";"Rögle BK - Skellefteå";"Swedish" "d4c:46:21";"20091008190000";"Södertälje - Brynäs";"Swedish" "d4b:46:2";"20091008190000";"HV 71 - Färjestad";"Swedish" "838:46:b";"20091010160000";"Skellefteå - HV 71";"Swedish"... (2 Replies)
Discussion started by: condmaster
2 Replies

4. Shell Programming and Scripting

File date format how to change

Hi All, Below are the unix files taken by the help of ls -lrt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 13:33 sand.txt -rw-r--r-- 1 kbehera Domain Users 4 Jul 27 13:37 sand1.txt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 15:30 new_sand.txt -rw-r--r-- 1 kbehera Domain Users 0 Jul 27... (2 Replies)
Discussion started by: krupasindhu18
2 Replies

5. Shell Programming and Scripting

Changing date format in CSV file

I have a CSV file with a date format like this; 11/19/2012 17:37:00,1.372,121.6 11/19/2012 17:38:00,0.743,121.6 Want to change the time stamp to seconds after 1970 so I can get the data in rrdtool. For anyone interested, this is data from a TED5000 unit and is Kwatts and volts. Needs to... (3 Replies)
Discussion started by: ottsm
3 Replies

6. Shell Programming and Scripting

How to change the format of the date column in a flat file?

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

7. Shell Programming and Scripting

Datestamp format 2nd change in csv file (awk or sed)

I have a csv file formatted like this: 2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07and I'm trying to change it to MM/DD/YYYY HH:MM for both occurances. I have got this: awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csvThis... (6 Replies)
Discussion started by: say170
6 Replies

8. Shell Programming and Scripting

Need to change date format in a csv file using awk

Example: Input csv file 00245DLS,Sitel Ocala,12/31/2014,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel Ocala,12/31/2014,19:00,-1.00,-1.00,-1.00,-1.00 00245HB,Charlotte,01/01/2015,00:00,-1.00,-1.00,-1.00,0.00 Output csv file 00245DLS,Sitel Ocala,2014/12/31,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel... (8 Replies)
Discussion started by: adit
8 Replies

9. Shell Programming and Scripting

Change date format in am/pm in csv files using UNIX

Hi All, I'm new to forum good to hear all. I stuck in converting date format in csv file using unix csv file contains as below ,750,0000000000000000GCJR, ,06/22/2016 14:48:44 I want to convert into as below ,750,0000000000000000GCJR, ,06/22/2016 02:48:44 PM Please reply asap..... (22 Replies)
Discussion started by: Raghureds
22 Replies

10. UNIX for Beginners Questions & Answers

Change date format in a file.

Hi all, I have a file as below, i would like the change the format of the time from "11/7/2019 20:12" to "2019-07-11 20:12:00" in the last coloumn. any awk solution on this. Input: 2,0,695016,1961612,497212,5800804,0,0,161,33,7605,12226,23,10,66,0,0,34,11/7/2019 20:10... (4 Replies)
Discussion started by: Raghuram717
4 Replies
Gtk2::Calendar(3)					User Contributed Perl Documentation					 Gtk2::Calendar(3)

NAME
Gtk2::Calendar HIERARCHY
Glib::Object +----Glib::InitiallyUnowned +----Gtk2::Object +----Gtk2::Widget +----Gtk2::Calendar INTERFACES
Glib::Object::_Unregistered::AtkImplementorIface Gtk2::Buildable METHODS
widget = Gtk2::Calendar->new $calendar->clear_marks (year, month, day) = $calendar->get_date $calendar->set_detail_func ($func, $data=undef) o $func (scalar) o $data (scalar) Since: gtk+ 2.14 integer = $calendar->get_detail_height_rows Since: gtk+ 2.14 $calendar->set_detail_height_rows ($rows) o $rows (integer) Since: gtk+ 2.14 integer = $calendar->get_detail_width_chars Since: gtk+ 2.14 $calendar->set_detail_width_chars ($chars) o $chars (integer) Since: gtk+ 2.14 $calendar->display_options ($flags) o $flags (Gtk2::CalendarDisplayOptions) The old name for "set_display_options". calendardisplayoptions = $calendar->get_display_options $calendar->set_display_options ($flags) o $flags (Gtk2::CalendarDisplayOptions) $calendar->freeze boolean = $calendar->mark_day ($day) o $day (integer) $widget->marked_date ($value) value = $widget->marked_date $widget->month ($value) value = $widget->month $widget->num_marked_dates ($value) value = $widget->num_marked_dates $calendar->select_day ($day) o $day (integer) boolean = $calendar->select_month ($month, $year) o $month (integer) o $year (integer) $widget->selected_day ($value) value = $widget->selected_day $calendar->thaw boolean = $calendar->unmark_day ($day) o $day (integer) $widget->year ($value) value = $widget->year PROPERTIES
'day' (integer : readable / writable / private) The selected day (as a number between 1 and 31, or 0 to unselect the currently selected day) 'detail-height-rows' (integer : readable / writable / private) Details height in rows 'detail-width-chars' (integer : readable / writable / private) Details width in characters 'month' (integer : readable / writable / private) The selected month (as a number between 0 and 11) 'no-month-change' (boolean : readable / writable / private) If TRUE, the selected month cannot be changed 'show-day-names' (boolean : readable / writable / private) If TRUE, day names are displayed 'show-details' (boolean : readable / writable / private) If TRUE, details are shown 'show-heading' (boolean : readable / writable / private) If TRUE, a heading is displayed 'show-week-numbers' (boolean : readable / writable / private) If TRUE, week numbers are displayed 'year' (integer : readable / writable / private) The selected year SIGNALS
month-changed (Gtk2::Calendar) day-selected (Gtk2::Calendar) day-selected-double-click (Gtk2::Calendar) prev-month (Gtk2::Calendar) next-month (Gtk2::Calendar) prev-year (Gtk2::Calendar) next-year (Gtk2::Calendar) ENUMS AND FLAGS
flags Gtk2::CalendarDisplayOptions o 'show-heading' / 'GTK_CALENDAR_SHOW_HEADING' o 'show-day-names' / 'GTK_CALENDAR_SHOW_DAY_NAMES' o 'no-month-change' / 'GTK_CALENDAR_NO_MONTH_CHANGE' o 'show-week-numbers' / 'GTK_CALENDAR_SHOW_WEEK_NUMBERS' o 'week-start-monday' / 'GTK_CALENDAR_WEEK_START_MONDAY' o 'show-details' / 'GTK_CALENDAR_SHOW_DETAILS' SEE ALSO
Gtk2, Glib::Object, Glib::InitiallyUnowned, Gtk2::Object, Gtk2::Widget COPYRIGHT
Copyright (C) 2003-2008 by the gtk2-perl team. This software is licensed under the LGPL. See Gtk2 for a full notice. perl v5.12.1 2010-07-05 Gtk2::Calendar(3)
All times are GMT -4. The time now is 11:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy