I have a timestamp(6) column in a .csv data file , format of the data is as below:-
I want the timestamp column to be properly formatted like
Currently the "0" is missing with date/month/hours for 200K some records.
I tried using AWK on this file -- but could change the value collectively and also in a file. & Any help how can i change the data to using AWK/SED etc?
Last edited by Franklin52; 01-08-2011 at 10:18 AM..
Reason: Please use code tags
Hi,
I have a file say abc. I get the timestamp in following way:
ls -ltr abc | awk -F" " '{print $6,$7,$8}'
Mar 8 10:23
I need to get the timestamp as :
03-08-2007 10:23:00
Thanks
Sumeet (1 Reply)
Hi , i need help with formatting a file i am generating which is to be used in mainframe app so the file length has to be 80 for each rows. The file that m able to generate looks like this (consists of two rows only)
E
1006756
1006756
Active
T
E
0551055
0551055
Active
T
I... (2 Replies)
Hi
I am dealing with the following string:
Date: Thur, 13 March 2011 01:01:10 +0000
I asked for help in another topic that converted a similar string:
Date: Thur, 13 March 2011 9:50 AM
To a 24 hr standard. The problem is that it comes out as:
Date: Thur, 13 March 2011 9:50:00 +0000... (4 Replies)
Hi all,
I'm a Unix newbie and I need to get file timestamp in the following format:
YYYYMMDD HH24:MM:SS
example:
20120713 18:49:30
For start I've tried the following code, but I don't know how to display the year and even format the date:
ls -l $filename | awk '{print $7 $6 $8}'
My... (4 Replies)
Hi,
Am having a file. I checked that file format by the following command
file filename
Output is
filename: data
So the file is data format file
Am trying to view that file so i have used some commands like cat,more so on but it showing the contents like compressed form(full of Symbols). How... (4 Replies)
hi all,
i am new to unix forum,i want do some large data format work. pls help me to format the file.
i have attched data file to be formated in that two set of line item is there . first set header & second set header to be come in to single header item same as like all the data also.
... (2 Replies)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Hello I have a file : file1.txt with the below contents :
237176 test1 test2 1442149024
237138 test3 test4 1442121300
237171 test5 test7 1442112823
237145 test9 test10 1442109600
In the above file fourth field represents the timestamp in Unix format.
I found a command which converts... (6 Replies)
Gurus,
I have a data file which has a certain number of columns say 101. It has one description column which contains foreign characters and due to this some times, those special characters are translated to new line character and resulting in failing the process.
I am using the following awk... (4 Replies)
I am on HP-UX B.11.11 OS. My requirement is to display a list of directories (not files) and the last modified time format should be DD-MON-YYYY HH:MI:SS AM/PM. I am able to get the list using either ls -lF | grep / OR ls -ld -- */ but I am unable to set the time format as I want. The... (5 Replies)
Discussion started by: nickz2017
5 Replies
LEARN ABOUT SUSE
truncate
TRUNCATE(1) User Commands TRUNCATE(1)NAME
truncate - shrink or extend the size of a file to the specifed size
SYNOPSIS
truncate OPTION... FILE...
DESCRIPTION
Shrink or extend the size of each FILE to the specified size
A FILE argument that does not exist is created.
If a FILE is larger than the specified size, the extra data is lost. If a FILE is shorter, it is extended and the extended part (hole)
reads as zero bytes.
Mandatory arguments to long options are mandatory for short options too.
-c, --no-create
do not create any files
-o, --io-blocks
Treat SIZE as number of IO blocks instead of bytes
-r, --reference=FILE
use this FILE's size
-s, --size=SIZE
use this SIZE
--help display this help and exit
--version
output version information and exit
SIZE is a number which may be followed by one of the following suffixes: KB 1000, K 1024, MB 1000*1000, M 1024*1024, and so on for G, T, P,
E, Z, Y.
SIZE may also be prefixed by one of the following modifying characters: `+' extend by, `-' reduce by, `<' at most, `>' at least, `/' round
down to multiple of, `%' round up to multiple of.
Note that the -r and -s options are mutually exclusive.
AUTHOR
Written by Padraig Brady.
REPORTING BUGS
Report truncate bugs to bug-coreutils@gnu.org
GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
General help using GNU software: <http://www.gnu.org/gethelp/>
COPYRIGHT
Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO dd(1), truncate(2), ftruncate(2)
The full documentation for truncate is maintained as a Texinfo manual. If the info and truncate programs are properly installed at your
site, the command
info coreutils 'truncate invocation'
should give you access to the complete manual.
GNU coreutils 7.1 July 2010 TRUNCATE(1)