https://userbase.kde.org/index.php?title=Kexi/Handbook/References/Supported_File_Formats/Comma-separated_Values_Format&feed=atom&action=historyKexi/Handbook/References/Supported File Formats/Comma-separated Values Format - Revision history2024-03-28T11:32:20ZRevision history for this page on the wikiMediaWiki 1.40.2https://userbase.kde.org/index.php?title=Kexi/Handbook/References/Supported_File_Formats/Comma-separated_Values_Format&diff=337532&oldid=prevJstaniek: Created page with "<languages/> <translate> ===Comma-separated Values Format (CSV)=== <!--T:2--> <!--T:3--> '''Kexi''' is capable of importing and exporting data from/to a variety of Comma-sep..."2014-08-27T21:52:49Z<p>Created page with "<languages/> <translate> ===Comma-separated Values Format (CSV)=== <!--T:2--> <!--T:3--> '''Kexi''' is capable of importing and exporting data from/to a variety of Comma-sep..."</p>
<p><b>New page</b></p><div><languages/><br />
<br />
<translate><br />
===Comma-separated Values Format (CSV)=== <!--T:2--><br />
<br />
<!--T:3--><br />
'''Kexi''' is capable of importing and exporting data from/to a variety of Comma-separated values formats (CSV files). Most spreadsheet and database applications can import and export in this format, making this an appropriate format to migrate textual data between different applications.<br />
<br />
<!--T:4--><br />
'''Kexi''' also supports a number of options that can be configured before performing import:<br />
<br />
<!--T:5--><br />
*data type for each column,<br />
<br />
<!--T:6--><br />
*other field delimiters such as tabs,<br />
<br />
<!--T:7--><br />
*different text quotes,<br />
<br />
<!--T:8--><br />
*given number of records can be skipped if needed,<br />
<br />
<!--T:9--><br />
*duplicated delimiters can be skipped,<br />
<br />
<!--T:10--><br />
*values from the first row can be used to set column names,<br />
<br />
<!--T:11--><br />
*text encoding (UTF-8 is the default),<br />
<br />
<!--T:12--><br />
*date format (defined by the operating system is the default),<br />
<br />
<!--T:13--><br />
*stripping leading and trailing blanks off of the text values.<br />
<br />
<!--T:14--><br />
On importing '''Kexi''' shows preview of imported data. Most suitable set of options is auto-detected by '''Kexi''' based on provided CSV file.<br />
<br />
<!--T:15--><br />
<!-- TODO more explanation of importing or add reference to section about Import --><br />
<br />
<!--T:39--><br />
[[Category:Kexi]]<br />
[[Category:Tutorials]]<br />
</translate></div>Jstaniek