Hi all,
If I have a flat file
ID|Location|Date|Hostname|Age|Sex
1|SFO|06/02/24 12:12:34|hawkeye|35|M
2|LAX|06/02/24 13:12:35|sf49ers|30|M
3|OAK|06/02/25 11:12:36|goraiders|27|F
4|PIT|06/02/25 12:12:37|steeler|35|M
How can I create an output
1|SFO|02/24/2006 12:12:34|hawkeye|35|M... (6 Replies)
Hi,
Is there any way we could change the date format listed below...
date I get is 03302007 (MMDDYYYY)
I need to change it to 20070330 (YYYYMMDD)
Thanks. (3 Replies)
Hi I have a very large csv file with some hundreds of thousands of rows of data.
The data is in the following format:
Up to four alpha numeric characters for the first word. This is either set as 2 characters followed by 2 spaces, or as a single 4character word. This is then followed by an 8... (7 Replies)
I have a data file. Seperated by "|". The 19 th filed is a date field that occurs like this
11/02/2001
i need to convert into the below format
2001-11-02
for e.g..
i/p
o/p should be
can somebody throw some light (5 Replies)
from this input
WEBELSOLAR,29122009,1:1
WIPRO,15062010,2:3
ZANDUREALT,18012007,1:3
i want output as
WEBELSOLAR,20091229,1:1
WIPRO,20100615,2:3
ZANDUREALT,20070118,1:3
basically input is in ddmmyyyy format and i was to convert it to yyyymmdd format (1 Reply)
Hi forum.
How do I change the following date value with another value (while keeping the rest of the line) using sed? The date values can change so I need a general sed command to change the date value within the first quotation marks only.
Date values will be coming from 2 different files.... (2 Replies)
Hi,
In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date×tamp. I have to figure out the the data is a date or time stamp or date×tamp.
If it is date then append "<space>00:00:00"... (1 Reply)
Hello people,
I am having problem to sort, sed and zero padding of column in csv file.
7th column only.
Input of csv file:
1,2,3,4,5,6,4/1/2010 12:00 AM,8
1,2,3,4,5,6,3/11/2010 9:39 AM,8
1,2,3,4,5,6,5/12/2011 3:43 PM,8
1,2,3,4,5,6,12/20/2009 7:23 PM,8
Output:... (5 Replies)
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
LEARN ABOUT DEBIAN
function::ctime
function::ctime
FUNCTION:(3stap) Time utility functions FUNCTION:(3stap)NAME
function::ctime - Convert seconds since epoch into human readable date/time string
SYNOPSIS
ctime:string(epochsecs:long)
ARGUMENTS
epochsecs
Number of seconds since epoch (as returned by gettimeofday_s)
DESCRIPTION
Takes an argument of seconds since the epoch as returned by gettimeofday_s. Returns a string of the form
"Wed Jun 30 21:49:08 1993"
The string will always be exactly 24 characters. If the time would be unreasonable far in the past (before what can be represented with a
32 bit offset in seconds from the epoch) the returned string will be "a long, long time ago...". If the time would be unreasonable far in
the future the returned string will be "far far in the future..." (both these strings are also 24 characters wide).
Note that the epoch (zero) corresponds to
"Thu Jan 1 00:00:00 1970"
The earliest full date given by ctime, corresponding to epochsecs -2147483648 is "Fri Dec 13 20:45:52 1901". The latest full date given by
ctime, corresponding to epochsecs 2147483647 is "Tue Jan 19 03:14:07 2038".
The abbreviations for the days of the week are 'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', and 'Sat'. The abbreviations for the months are
'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', and 'Dec'.
Note that the real C library ctime function puts a newline ('
') character at the end of the string that this function does not. Also note
that since the kernel has no concept of timezones, the returned time is always in GMT.
SystemTap Tapset Reference May 2013 FUNCTION:(3stap)