Microsoft stores Excel dates as the number of days since January 0, 1900 (yes, Jan 0).
Humans think of it as December 31 1899. This is the Epoch for MS Excel.
Those numbers are days since the start of the Epoch date. Most UNIXes use Jan 1, 1970.
Hi Folks,
I've to convert manually couple of *.xls files to *.csv files everyday :(
so i was just wondering if anyone could just help me with a shell script or awk script to automate the process :)
PS : Problem is that i cannot use any third party software for the conversion.
Thanking... (1 Reply)
Hi Guy's can someone help me in converting the following
I have a flat text file which has several thousand lines which I need to convert to a csv it's got a consistent format but basically want every time it hit's txt to create a new line with the subsequent lines comma delimited for example
... (6 Replies)
Hi,
I have a log file that contains information along the lines of the following:
=========
jobnumber 322761
start_time Tue May 19 19:42:37 2009
end_time Tue May 19 20:11:28 2009
failed 0
=========
jobnumber 322762
start_time Tue May 19 19:39:51 2009
end_time ... (4 Replies)
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
INput file attached in thread : Column widths at 24,73,82,87,121 characters (sed 's/./,/24;s/./,/73;s/./,/81;s/./,/87;s/./,/121;s/ *, */,/g' fixedinputfile >output.csv
). The client wants instead of hard coding the column widths as they are not fixed .he has given the hint stating that ( ... (3 Replies)
Hi,
I have one .csv file. I have 2 date columns present in file, column 2 and column 3.
I need to calculate how many days exist between 2 dates.
I am trying to subtract date column 2 from date column 3.
Eg: my file look likes
s.no, Start_date,End_Date
1, 7/29/2012,10/27/2012
2,... (9 Replies)
Hello,
I have a binary csv file that was created on 'Red Hat Enterprise Linux Server release 6.6'. Now we have transferred all files on Ubuntu 16.04.2 LTS/xenial
On opening the file in Ubuntu, there are special characters
... (8 Replies)
Discussion started by: nans
8 Replies
LEARN ABOUT DEBIAN
rdf::trine::exporter::csv
RDF::Trine::Exporter::CSV(3pm) User Contributed Perl Documentation RDF::Trine::Exporter::CSV(3pm)NAME
RDF::Trine::Exporter::CSV - Export RDF data to CSV
VERSION
This document describes RDF::Trine::Exporter::CSV version 1.000
SYNOPSIS
use RDF::Trine::Exporter::CSV;
DESCRIPTION
The RDF::Trine::Exporter::CSV class provides an API for serializing RDF data to CSV strings and files.
METHODS
"new ( sep_char => $sep_char, quote => $bool )"
Returns a new RDF::Trine::Exporter::CSV object. If $sep_char is provided, it is used as the separator character in CSV serialization,
otherwise a comma (",") is used.
"serialize_iterator_to_file ( $file, $iterator )"
Serializes the bindings objects produced by $iterator, printing the results to the supplied filehandle "<$fh">.
"serialize_iterator_to_string ( $iterator )"
Serializes the bindings objects produced by $iterator, returning the result as a string.
BUGS
Please report any bugs or feature requests to through the GitHub web interface at <https://github.com/kasei/perlrdf/issues>.
AUTHOR
Gregory Todd Williams "<gwilliams@cpan.org>"
COPYRIGHT
Copyright (c) 2006-2012 Gregory Todd Williams. This program is free software; you can redistribute it and/or modify it under the same terms
as Perl itself.
perl v5.14.2 2012-06-29 RDF::Trine::Exporter::CSV(3pm)