07-02-2015
Date format change in a csv file
Hi,
We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places
But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script.
Please let us know how can we achieve the same.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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
EREG(3) 1 EREG(3)
ereg - Regular expression match
SYNOPSIS
int ereg (string $pattern, string $string, [array &$regs])
DESCRIPTION
Searches a $string for matches to the regular expression given in $pattern in a case-sensitive way.
Warning
This function has been DEPRECATED as of PHP 5.3.0. Relying on this feature is highly discouraged.
PARAMETERS
o $pattern
- Case sensitive regular expression.
o $string
- The input string.
o $regs
- If matches are found for parenthesized substrings of $pattern and the function is called with the third argument $regs, the
matches will be stored in the elements of the array $regs. $regs[1] will contain the substring which starts at the first left
parenthesis; $regs[2] will contain the substring starting at the second, and so on. $regs[0] will contain a copy of the complete
string matched.
RETURN VALUES
Returns the length of the matched string if a match for $pattern was found in $string, or FALSE if no matches were found or an error
occurred.
If the optional parameter $regs was not passed or the length of the matched string is 0, this function returns 1.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 4.1.0 | |
| | |
| | Up to (and including) PHP 4.1.0 $regs will be |
| | filled with exactly ten elements, even though |
| | more or fewer than ten parenthesized substrings |
| | may actually have matched. This has no effect on |
| | ereg(3)'s ability to match more substrings. If no |
| | matches are found, $regs will not be altered by |
| | ereg(3). |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
ereg(3) example
The following code snippet takes a date in ISO format (YYYY-MM-DD) and prints it in DD.MM.YYYY format:
<?php
if (ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $date, $regs)) {
echo "$regs[3].$regs[2].$regs[1]";
} else {
echo "Invalid date format: $date";
}
?>
NOTES
Note
As of PHP 5.3.0, the regex extension is deprecated in favor of the PCRE extension. Calling this function will issue an E_DEPRECATED
notice. See the list of differences for help on converting to PCRE.
Tip
ereg(3) is deprecated as of PHP 5.3.0. preg_match(3) is the suggested alternative to this function.
SEE ALSO
eregi(3), ereg_replace(3), eregi_replace(3), preg_match(3), strpos(3), strstr(3), quotemeta(3).
PHP Documentation Group EREG(3)