Sponsored Content
Top Forums Shell Programming and Scripting Change date format in am/pm in csv files using UNIX Post 302976530 by pravin27 on Thursday 30th of June 2016 09:03:38 AM
Old 06-30-2016
Code:
echo ",750,0000000000000000GCJR, ,06/22/2016 11:48:44"  | awk -F"," '{
hr=substr($NF,12,2);
if (hr > 11) { b="PM"
hr-12 == 0 ? nhr=hr : nhr=hr-12
} else { b="AM";nhr=hr}
printf "%s%02d%s %s\n",substr($NF,1,11),nhr,substr($NF,14),b}'

I guess your date version is not GNU. Could you please try above code
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to Change the Format of a Date

Hi All, this is my second post, last post reply was very helpful. I have a data that has date in DD/MM/YYYY (07/11/2008) format i want to replace the backslash by a dot(.) so that my awk script can read it inside the C shell script that i have written. i want to change 07/11/2008 to... (3 Replies)
Discussion started by: asirohi
3 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

Retaining the Unix CSV format in Excel format while exporting

Hi All, I have created a Unix Shell script whch creates a *.csv file and export it to Excel. The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example : if the Amount has the value as 3000000 User wants to be in 3,000,000 format. This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies

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

5. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

6. Shell Programming and Scripting

Change the date and time format in UNIX script.

Hi, I am extracting a date string from the source file like this : 06/05/2014 16:04:00 I want to change it to 05-JUN-14 04.05.00.000000000 PM I basically store the date in a variable. I got solutions to change date in dd-mmm-yyyy format using tr but I guess it works only with the "date"... (8 Replies)
Discussion started by: Varshha
8 Replies

7. Shell Programming and Scripting

Date format change in UNIX .dat file

Hi, I need help to convert the date format in .DAT file in unix. I want to convert 10@@|SWIFT MT568 Extract@@|Apr 14 2014 5:47:52:563PM@@|Apr 14 2014 4:33:47:663PM@@||##| into 10@@|SWIFT MT568 Extract@@|04/14/2014/ 5:47:52:563PM@@|04/14/2014 4:33:47:663PM@@||##| Appreciate... (18 Replies)
Discussion started by: karthikengox
18 Replies

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

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

10. Shell Programming and Scripting

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. (16 Replies)
Discussion started by: dholea
16 Replies
HFS(1)							      General Commands Manual							    HFS(1)

NAME
hfs - shell for manipulating HFS volumes SYNOPSIS
hfs [hfs-path [partition-no]] DESCRIPTION
hfs is an interactive command-oriented tool for manipulating HFS volumes. hfs is based on the Tcl interpreter, so basic Tcl constructs can be used in addition to the following commands: mount path [partition-no] The specified UNIX path is opened as an HFS volume. If a partition number n is specified and the volume source is located on a par- titioned medium, the nth discovered HFS partition will be mounted. The default partition-no is 1. umount [path] The volume previously mounted from the specified path (or the current volume, if none specified) is unmounted. vol path The volume previously mounted from the specified path is made current. info General information about the currently mounted volume is displayed. This information is also displayed automatically when the vol- ume is mounted. pwd The full path to the current working HFS directory is displayed. cd [hfs-path] The current working directory is changed to the given HFS path. If no path is given, the working directory is changed to the root of the volume. dir [hfs-path] A directory listing of the specified HFS directory is displayed. If no path is given, the contents of the current working directory are shown. mkdir hfs-path A new, empty directory is created with the specified path. rmdir hfs-path The specified directory is removed. It must be empty. create hfs-path [type [creator]] An empty file is created with the specified path. The Macintosh type and creator may be specified, or they will default to TEXT and UNIX, respectively. del hfs-path Both forks of the specified file are deleted. stat hfs-path Status information about the specified HFS path-identified entity is displayed. cat hfs-path The data fork of the specified HFS file is displayed. copyin unix-path [hfs-path [mode]] The specified UNIX file is copied to the named HFS destination path. Unless specified otherwise, the file will be copied into the current HFS working directory using a heuristically chosen mode. The mode may be one of: macb (MacBinary II), binh (BinHex), text, or raw. copyout hfs-path [unix-path [mode]] The specified HFS file is copied into the named UNIX destination path. Unless specified otherwise, the file will be copied into the current UNIX working directory using a heuristically chosen mode. The modes are the same as for copyin. format path [partition-no [volume-name]] The specified UNIX path is initialized as an empty HFS volume with the given name, and this volume is subsequently mounted. The default volume name is Untitled. The shell is scriptable, however it should be understood that the above commands are actually implemented by Tcl procedures prefixed with the character "h", e.g. hmount, hcd, etc., in order to avoid name collisions with other Tcl utilities. The "h" may be omitted in interac- tive use for convenience. SEE ALSO
hfsutils(1), xhfs(1) BUGS
cat can only display the data fork of a file. Text translations are performed unconditionally on the output. Furthermore, binary data can- not be handled properly from within Tcl scripts since the character with value 0 cannot be represented in Tcl strings. Use copyout to copy files without these limitations. AUTHOR
Robert Leslie <rob@mars.org> HFSUTILS
15-Jan-1997 HFS(1)
All times are GMT -4. The time now is 11:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy