Line 1: |
Line 1: |
− | == TSG suggested File Format For Dummies (WIP by Arvind for extra readability!) == | + | == TSG suggested file format for experiment data == |
| The TSG suggests the following file format for data storage for most experiments. | | The TSG suggests the following file format for data storage for most experiments. |
| | | |
− | * Field delimiter: tab (also after last field) | + | ===== Lines ===== |
− | * Line delimiter: \r\n (also after last line) | + | * Lines are separated by the '''\r\n''' line delimiter for better compatibility between operating systems. |
− | * Quoting character: none | + | * The line delimiter should also be added after the last line, because... |
− | * File extension: "tsv" | + | * The first line contains a header with column/field names. |
− | * File encoding: ASCII / UTF-8 | + | |
− | * Magic number: none | + | ===== Fields ===== |
− | * First line contains header, not data
| + | * Field are separated by the '''tab''' field delimiter, because they rarely occur in texts and therefore require no escaping. |
| + | * The field delimiter should also be added after each line's last field, because... |
| + | * The last field in a line must not be empty, because... if there is no value, wat do... |
| + | * Fields are not surrounded by a quoting character. |
| + | * White space between field delimiters are considered part of the field. |
| + | * There is no defined escape character. If your data can contain tabs, use a different field delimiter or file format. |
| + | |
| + | ===== File ===== |
| + | * The file is encoded as ASCII or UTF-8. |
| + | * The file contains no byte order mark (BOM) or other magic number. |
| + | |
| * Last field must not be empty (what if no data?) | | * Last field must not be empty (what if no data?) |
| | | |
| Explanation for these choices (also nice for ourselves). In progress.. | | Explanation for these choices (also nice for ourselves). In progress.. |
| | | |
− | | + | # |
| | | |
| == File Format == | | == File Format == |