I have a CSV file with a date format like this;
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 look like;
I know that the date command will convert the time;
And that the sed command will search and replace. Just trying the best way to get the data in the correct format and then use the update command in rrdtool to get the data in the rrd data base.
Last edited by Franklin52; 11-23-2012 at 03:10 AM..
Reason: Please use code tags for data and code samples
Hi,
There are lots of threads about how to manipulate the date using date +%m %.......
But how can I change the default format of the commad date?
$ date
Mon Apr 10 10:57:15 BST 2006
This would be on fedora and SunOs.
Cheers,
Neil (4 Replies)
Hi Experts,
Please help me to get the following from script for Unix ENvironment(shell, perl, tr, sed, awk).
INPUT FILE:
20K,ME,592971
20K,YOU,2
20K,HE,1244998
50K,YOU,480110
50K,ME,17
50K,HIS,10
50K,HE,1370391
OUTPUT FILE:
K,ME,YOU,HE,HIS
20K,592971,2,1244998,0... (5 Replies)
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)
I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd.
The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4".
This is what I use to change the format:
sed -i '' -e... (2 Replies)
Hi...
I have an inputfile name as :- abc_test_20120213.dat (date in yyyymmdd format)
I need the output file name as abc_test_13022012.dat (date in ddmmyyyy format)
Please help me on this...
Thanks in advance. (5 Replies)
Hi all,
I have a file with below data
af23b|11-FEB-12|acc7
ad23b|12-JAN-12|acc4
as23b|15-DEC-11|acc5
z123b|18-FEB-12|acc1
I need the output as below:-(date in yyyymmdd format)
af23b|20120211|acc7
ad23b|20120112|acc4
as23b|20111215|acc5
z123b|20120218|acc1
Please help me on this.... (7 Replies)
How can i make the date command output yesterday's date, current date and the date 4 days ago, in the following format:
2012-10-03
code:
date +% ???? (3 Replies)
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)
Hi All,
I have a CSV file which is as below. Basically I need to take the year column in it and find if the year is >= 20152 . If that is then I should subtract all values by 6. In the below example in description I am having number mentioned as YYWW so I need to subtract those by -5. Whereever... (8 Replies)
Discussion started by: arunkumar_mca
8 Replies
LEARN ABOUT DEBIAN
mdb-export
MDBTools(1)MDBTools(1)NAME
mdb-export - Export data in an MDB database table to CSV format.
SYNOPSIS
mdb-export [-H] [-d delimiter] [-R row_delim] [[-Q] | [-q quote [-X escape]]] [-I] [-D format] database table
DESCRIPTION
mdb-export is a utility program distributed with MDB Tools.
It produces a CSV (comma separated value) output for the given table. Such output is suitable for importation into databases or spread-
sheets.
OPTIONS -H Supress header row
-Q Don't wrap text-like fields (text, memo, date) in quotes. If not specified text fiels will be surrounded by " (double quote) char-
acters.
-d Specify an alternative column delimiter If no delimiter is specified, table names will be delimited by a , (comma) character.
-R Specify a row delimiter
-I INSERT statements (instead of CSV). You must specify the SQL dialect.
-D Set the date format (see strftime(3) for details)
-q Use to wrap text-like fields. Default is ".
-X Use to escape quoted characters within a field. Default is doubling.
-N namespace
Prefix identifiers with namespace.
NOTES ENVIRONMENT
MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).
MDBICONV
Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.
MDBOPTS
semi-column separated list of options:
o use_index
o no_memo
o debug_like
o debug_write
o debug_usage
o debug_ole
o debug_row
o debug_props
o debug_all is a shortcut for all debug_* options
SEE ALSO gmdb2(1)mdb-hexdump(1)mdb-prop(1)mdb-sql(1)mdb-ver(1)mdb-array(1)mdb-header(1)mdb-parsecsv(1)mdb-schema(1)mdb-tables(1)HISTORY
mdb-export first appeared in MDB Tools 0.1.
AUTHORS
The mdb-export utility was written by Brian Bruns.
BUGS
Memo fields are allowed to contain a newline characters, the current program does nothing about this.
0.7 13 July 2013 MDBTools(1)