csv is a supported tabular file data resource.
A csv file may get the following data attributes:
| Name | Default Value | Description |
|---|---|---|
| comment-character | # | The character that if found as the first character of a line makes the line a comment |
| delimiter-character | , | The character that delimits every fields (ie columns) |
| escape-character | null | The character that when found before a CSV character, set it as a character and not as a property |
| header-row-id | 1 | The row id where the header is located (0 means no header and 1 the first line) |
| ignore-empty-line | true | Empty line are ignored |
| quote-character | " | The character that enclose a field value. |
Because a csv file is also a text file, you can also set text attributes
Example of attributes setting in a kind resource manifest
kind: csv
spec:
data-def:
logical-name: favorite_books
header-row-id: 1
delimiter-character: ','
columns:
- name: asin
type: varchar
precision: 20
- name: description
type: varchar
- name: price
type: double
- name: group
type: varchar
You can then use the manifest for any data operation on the csv file
tabul data print books--csv.yml@howto
books.csv@md
asin description price group
------------- ------------------------------------------- ----- ----------
B007US9NA8 The New Encyclopedia of Modern Bodybuilding 27.18 Sports
1439199191 How To Win Friends And Influence People 27.18 Psychology
9780465050659 The Design of Everyday Things 9.99 Design
9780465050659 The Design of Everyday Things 9.99 Psychology
B00555X8OA Thinking, Fast and Slow 8.85 Decision
B00555X8OA Thinking, Fast and Slow 8.85 Psychology