|
Written by Pete Nurse
|
|
You may have noticed that Jix file names have numeric suffixes such as users_044.csv, categories_124.csv etc. This suffix is the ASCII code for the delimiter used in this file. Why does Jix use different delimiters? How do you use different delimiters?
Jix uses Delimiter Separated Value (DSV) files as its data interchange medium. The most common form of delimited text files is the Comma Separated Variable (CSV) file. For instance, CSV files maybe opened directly in Microsoft Excel and Open Office or imported into Microsoft Access.
For many Jix applications, CSV files are quite adequate. However, when there are commas embedded in the data, the use of CSV files fails since each comma is interpreted as a new field. Therefore, Jix offers you complete control over the delimiter used in your DSV files.
You may set your file configuration from the Jix Configuration tab.
Note: There are several versions of the extended ASCII characters. See www.lookuptables.com for the PHP/Jix version. |