<p></p>
<p>Wolf Halton<br>
<a href="http://sourcefreedom.com">http://sourcefreedom.com</a><br>
Apache developer:<br>
<a href="mailto:wolfhalton@apache.org">wolfhalton@apache.org</a></p>
<p>On Sep 14, 2012 8:41 PM, "Jay Lozier" <<a href="mailto:jslozier@gmail.com">jslozier@gmail.com</a>> wrote:<br>
><br>
> On 09/14/2012 07:15 PM, Wolf Halton wrote:<br>
>><br>
>> Wolf Halton<br>
>> <a href="http://sourcefreedom.com">http://sourcefreedom.com</a><br>
>> Apache developer:<br>
>> <a href="mailto:wolfhalton@apache.org">wolfhalton@apache.org</a><br>
>><br>
>> On Sep 14, 2012 10:26 AM, "Jay Lozier" <<a 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?<br>
>><br>
>> your import won't fail because the delimiter is wrong after changing the name?<br>
>><br>
>> just curious<br>
>><br>
>> Wolf<br>
><br>
> 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>
></p>
<p>>> ><br>
>> > --<br>
>> > Jay Lozier<br>
>> > <a href="mailto:jslozier@gmail.com">jslozier@gmail.com</a><br>
>> ><br>
>> > _______________________________________________<br>
>> > Ale mailing list<br>
>> > <a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
>> > <a 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 href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> Ale mailing list<br>
>> <a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
>> <a 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 href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a><br>
><br>
><br>
><br>
> -- <br>
> Jay Lozier<br>
> <a href="mailto:jslozier@gmail.com">jslozier@gmail.com</a><br>
><br>
><br>
> _______________________________________________<br>
> Ale mailing list<br>
> <a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
> <a 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 href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a><br>
><br>
</p>