Zen

Source string Source string

110/10000 · 110
English Actions
Load a CSV file
:ref:`csv.dump() <csv-dump>`
Transform input into a CSV-formatted string
:ref:`csv.iterate() <csv-iterate>`
Iterate over CSV records
Get CSV-formatted input from ``readable`` and return a table as output. Usually ``readable`` is either a string or a file opened for reading. Usually :samp:`{options}` is not specified.
Parameters
a string, or any object which has a read() method, formatted according to the CSV rules
see :ref:`above <csv-options>`
return
loaded_value
rtype
table
**Example:**
Readable string has 3 fields, field#2 has comma and space so use quote marks:
tarantool> csv = require('csv')
---
...
tarantool> csv.load('a,"b,c ",d')
---
- - - a
- 'b,c '
- d
...
Readable string contains 2-byte character = Cyrillic Letter Palochka: (This displays a palochka if and only if character set = UTF-8.)
tarantool> csv.load('a\\211\\128b')
---
- - - a\211\128b
...
Semicolon instead of comma for the delimiter:
tarantool> csv.load('a,b;c,d', {delimiter = ';'})
---
- - - a,b
- c,d
...
Readable file :file:`./file.csv` contains two CSV records. Explanation of ``fio`` is in section :ref:`fio <fio-section>`. Source CSV file and example respectively:
tarantool> -- input in file.csv is:
tarantool> -- a,"b,c ",d
tarantool> -- a\\211\\128b
tarantool> fio = require('fio')
---
...
tarantool> f = fio.open('./file.csv', {'O_RDONLY'})
---
...
tarantool> csv.load(f, {chunk_size = 4096})
---
- - - a
- 'b,c '
- d
- - a\\211\\128b
...
tarantool> f:close()
---
- true
...
Get table input from ``csv-table`` and return a CSV-formatted string as output. Or, get table input from ``csv-table`` and put the output in ``writable``. Usually :samp:`{options}` is not specified. Usually ``writable``, if specified, is a file opened for writing. :ref:`csv.dump() <csv-dump>` is the reverse of :ref:`csv.load() <csv-load>`.
a table which can be formatted according to the CSV rules.
optional. see :ref:`above <csv-options>`
any object which has a ``write()`` method
dumped_value
string, which is written to ``writable`` if specified
CSV-table has 3 fields, field#2 has "," so result has quote marks
tarantool> csv = require('csv')
---
...
tarantool> csv.dump({'a','b,c ','d'})
---
- 'a,"b,c ",d

'
...
Round Trip: from string to table and back to string

Loading…

User avatar None

New source string

testing_project / Documentation: reference/reference_lua/csv — English

tarantool> csv = require('csv')
---
...
tarantool> csv.load('a,"b,c ",d')
---
- - - a
- 'b,c '
- d
...
2 years ago
Browse all string changes

Things to check

Ellipsis

The string uses three dots (...) instead of an ellipsis character (…)

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
String age
2 years ago
Last updated
2 years ago
Source string age
2 years ago
Translation file
string 36