<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 09/14/2012 07:15 PM, Wolf Halton
wrote:<br>
</div>
<blockquote
cite="mid:CALRLYEmcLPafUyvgtj99Lf7wai_q4n_UdeYuSBZLb=ggNJyYcw@mail.gmail.com"
type="cite">
<p>Wolf Halton<br>
<a moz-do-not-send="true" href="http://sourcefreedom.com">http://sourcefreedom.com</a><br>
Apache developer:<br>
<a moz-do-not-send="true" href="mailto:wolfhalton@apache.org">wolfhalton@apache.org</a><br>
</p>
<p>On Sep 14, 2012 10:26 AM, "Jay Lozier" <<a
moz-do-not-send="true" href="mailto:jslozier@gmail.com">jslozier@gmail.com</a>>
wrote:<br>
><br>
> Hi,<br>
><br>
> I saw a question about importing a *.tsv (tab delimited
text files) into<br>
> a spreadsheet. The problem is *.tsv are unusual while *.csv
are common.<br>
><br>
> My question is how does one change the file extension of
many *.tsv to<br>
> *.csv files?</p>
<p>your import won't fail because the delimiter is wrong after
changing the name? </p>
<p>just curious</p>
<p>Wolf</p>
</blockquote>
Wolf,<br>
<br>
LO Calc (the spreadsheet being used) allows you to change the
delimiter of the csv file. I use this feature often to change the
delimiter to a tab or semicolon. Sometimes commas are used a
punctuation within the dataset (XYX Corp, Inc. in a company field)
which can cause problems when importing into spreadsheet or
database. Importing into MySQL/MariaDB requires one to specify the
delimiter used as well as the file type.<br>
<br>
<blockquote
cite="mid:CALRLYEmcLPafUyvgtj99Lf7wai_q4n_UdeYuSBZLb=ggNJyYcw@mail.gmail.com"
type="cite">
<p>><br>
> --<br>
> Jay Lozier<br>
> <a moz-do-not-send="true" href="mailto:jslozier@gmail.com">jslozier@gmail.com</a><br>
><br>
> _______________________________________________<br>
> Ale mailing list<br>
> <a moz-do-not-send="true" href="mailto:Ale@ale.org">Ale@ale.org</a><br>
> <a moz-do-not-send="true"
href="http://mail.ale.org/mailman/listinfo/ale">http://mail.ale.org/mailman/listinfo/ale</a><br>
> See JOBS, ANNOUNCE and SCHOOLS lists at<br>
> <a moz-do-not-send="true"
href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a><br>
</p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Ale mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Ale@ale.org">Ale@ale.org</a>
<a class="moz-txt-link-freetext" href="http://mail.ale.org/mailman/listinfo/ale">http://mail.ale.org/mailman/listinfo/ale</a>
See JOBS, ANNOUNCE and SCHOOLS lists at
<a class="moz-txt-link-freetext" href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Jay Lozier
<a class="moz-txt-link-abbreviated" href="mailto:jslozier@gmail.com">jslozier@gmail.com</a></pre>
</body>
</html>