How to extract start/end times from log file to CSV file?
Hi,
I have a log file (log.txt) that which contains lines of date/time.
I need to create a script to extract a CSV file (out.csv) that gets all the sequential times (with only 1 minute difference) together by stating the start time and end time of this period.
Sample log file (log.txt)
The CSV out file should look something like the below:
The first column of each line is the start time, the second column is the end time, and the third column is the number of minutes between the start and end times.
Hi
I'm running 4 jobs in the background and I need to write the start and end times to a log file. I know there's probably a simple way to do this but, I can't think of it. I've used nohup <script name> & but, that doesn't record the times. Is there a way to get the start and end times of a... (2 Replies)
hi
In the foll example the whole text in a single line....
i want to extract text from IPTel to RTCPBase.h.
want to use this acrooss the whole file
Updated: IPTel\platform\core\include\RTCPBase.h \main\MWS2051_Sablime_Int\1... (7 Replies)
Hello People,
I have the following contents in an XML file
...........
...........
..........
...........
<Details = "Sample Details">
<Name>Bob</Name>
<Age>34</Age>
<Address>CA</Address>
<ContactNumber>1234</ContactNumber>
</Details>
...........
.............
.............. (4 Replies)
Hi
I have a ksh script which fetches data from a db using a number of .arc files and creates CSV files for them and puts them on the server.
Question is, can I specifiy the start and stop times manually and run the script manually to fetch data for a certain period?
# Get the current... (0 Replies)
Hi
I have a ksh script which fetches data from a db using a number of .arc files and creates CSV files for them and puts them on the server.
Question is, how can I specifiy the start and stop times specifically so that data is fetched for a certain period?
# Get the current time as the... (1 Reply)
Hi All,
I am having an XML tag like:
<detail sim_ser_no_1="898407109001000090"
imsi_1="452070001000090">
<security>ADM1=????</security>
<security>PIN1=????</security>
<security>PIN2=????</security>
... (2 Replies)
I'd like to copy strings from a log file and put them into a CSV.
The strings could be on different line numbers, depending on size of log.
Example Log File:
File = foo.bat
Date = 11/11/11
User = Foo Bar
Size = 1024
...
CSV should look like:
"foo.bat","11/11/11","Foo Bar","1024" (7 Replies)
Hi, I have a file1 of many long sequences, each preceded by a unique header line. file2 is 3-columns list: headers name, start position, end position. I'd like to extract the sequence region of file1 specified in file2.
Based on a post elsewhere, I found the code:
awk... (2 Replies)
Hi friend i have input as following XML file
<?xml version="1.0"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.054.001.02">
<BkToCstmrDbtCdtNtfctn>
<GrpHdr><MsgId>LBP-RDJ-TE000000-130042430010001001</MsgId><CreDtTm>2013-01-04T03:21:30</CreDtTm></GrpHdr>... (3 Replies)
I have a file which looks something as following, I would like to split to several files, The start and end of each file is 'FILE' and end with 'ASCII... ' .
At the same time for each file in the first column add 100 and also second column add 100 the rest of the column as it is , see example of... (2 Replies)
Discussion started by: tk2000
2 Replies
LEARN ABOUT CENTOS
dm_zdump
DM_ZDUMP(1) User Contributed Perl Documentation DM_ZDUMP(1)NAME
dm_zdump - timezone dumper
SYNOPSIS
This performs the same operation as the unix 'zdump' command, but using the Date::Manip module.
dm_zdump [-v] [-c YEAR] [ZONE ZONE ...]
DESCRIPTION
This displays the current time in each ZONE named on the command line unless the -v option is given.
-h, --help
Print online help.
-v, --verbose
This displays all critical dates (i.e. the times when a time change occurs due to the timezone description) for each of the timezones
listed (or the local timezone if none are listed).
Each critical date is printed as two lines of output: the last second before the change occurs, and the first second of the new time.
By default, all critical dates from Jan 1, 0001 until the year 20 years in the future are printed, but this can be changed with the -c
option.
-c, --cutoff YEAR
This specifies the cutoff year. All critical dates up to the start of YEAR are given. The GMT time Jan 01, YEAR at 00:00:00 is the
cutoff time.
KNOWN BUGS
None known.
BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author.
SEE ALSO
Date::Manip::Date
LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
AUTHOR
Sullivan Beck (sbeck@cpan.org)
perl v5.16.3 2014-06-09 DM_ZDUMP(1)