1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
|
### jsoncons::csv::basic_csv_options
```cpp
#include <jsoncons_ext/csv/csv_options.hpp>
template<
typename CharT
> class basic_csv_options;
```
<br>
Specifies options for reading and writing CSV data.
Option|Reading|Writing|Default
------|-------|-------|-------
flat (since 1.2.0)| |Indicates whether the encoder should process JSON as "flat" (without navigating through nested structures)|**true**
max_nesting_depth (since 1.2.0)| |Maximum nesting depth allowed in the input when encoding nested JSON to CSV|**1024**
column_mapping (since 1.2.0)| |Maps column paths identified by JSONPointers to plain names|No column mappings
nan_to_str|Substitute string with `NaN`, if enabled|Sets a string replacement for `NaN` when writing JSON
inf_to_str|Substitute string with `infinity`, if enabled|Sets a string replacement for infinity when writing JSON
neginf_to_str|Substitute string with `negative infinity`, if enabled|Sets a string replacement for negative infinity when writing JSON
nan_to_num| |Sets a number replacement for `NaN` when writing JSON
inf_to_num| |Sets a number replacement for `Infinity` when writing JSON
neginf_to_num| |Sets a number replacement for `Negative Infinity` when writing JSON
line_delimiter|Not used. When reading, the parser accepts `\n`, `\r` and `\r\n`.|An end-of-line string that marks the end of a row.|**'\n'**
field_delimiter|A character that indicates the end of a field.|Character to separate values.|**','**
subfield_delimiter|A character that indicates the end of a single value in a multi-valued field.|Character to write between items in an array value.|No multivalued fields
quote_char|A character to quote fields.|A character to quote fields.|**'"'**
quote_escape_char|A character to escape quote characters occuring inside quoted fields. |Character to escape quote characters occurring inside quoted fields.|double quote character (quote character is doubled)
quote_style| |Indicates what [quote_style](quote_style_kind.md) to use when quoting fields. |**minimal**
column_names|Use these column names when reading the file.|Write these column names to the header line.
header_lines|Number of header lines in the CSV text.|**1** if assume_header is true, otherwise **0**
assume_header|Assume first row in file is header, use field names to construct objects.| |**false**
skip_header|Skip the first (header) line of input.| |**false**
ignore_empty_values|Do not read CSV fields that have empty values.| |**false**
ignore_empty_lines|If set to true, all lines in the file that are empty (apart from record delimiter characters) are ignored. To ignore lines with only spaces or tabs, set trim to true.| |**true**
trim_leading|Trim leading whitespace.| |**false**
trim_trailing|Trim trailing whitespace.| |**false**
trim|Trim both leading and trailing whitespace.| |**false**
trim_leading_inside_quotes|Trim leading whitespace inside quote characters.| |**false**
trim_trailing_inside_quotes|Trim trailing whitespace inside quote characters.| |**false**
trim_inside_quotes|Trim both leading and trailing whitespace inside quote characters.|| **false**
unquoted_empty_value_is_null|Replace empty field with json null value.| |**false**
infer_types|Infer null, true, false, integers and floating point values in the CSV source.| |**true**
lossless_number|If set to **true**, parse numbers with exponents and fractional parts as strings with semantic tagging `semantic_tag::bigdec`.| |**false**
comment_starter|Character to comment out a line, must be at column 1| |None
mapping_kind|Indicates what [mapping kind](csv_mapping_kind.md) to use when parsing a CSV file into a `basic_json`.| |`csv_mapping_kind::n_objects` if assume_header is true or column_names is not empty, otherwise `csv_mapping_kind::n_rows`.|
max_lines|Maximum number of lines to read.| |Unlimited
column_types|A comma separated list of data types corresponding to the columns in the file. The following data types are supported: string, integer, float and boolean. Example: "bool,float,string"}|
column_defaults|A comma separated list of strings containing default json values corresponding to the columns in the file. Example: "false,0.0,"\"\""|
float_format| |Overrides [floating point format](../corelib/float_chars_format.md) when serializing to CSV.| |[float_chars_format::general](float_chars_format.md).
precision| |Overrides floating point precision when serializing csv from json.|Shortest representation.
Aliases for common character types are provided:
Type |Definition
--------------------|------------------------------
`csv_options` |`basic_csv_options<char>`
`wcsv_options` |`basic_csv_options<wchar_t>`
Member type |Definition
------------------------------------|------------------------------
`char_type`|`CharT`
`string_type`|`std::basic_string<CharT>`
#### Constructors
basic_csv_options()
Constructs a `basic_csv_options` with default values.
basic_csv_options(const basic_csv_options& other)
Copy constructor.
basic_csv_options(basic_csv_options&& other)
Move constructor.
#### Setters
basic_csv_options& flat(bool value); // (since 1.2.0)
basic_csv_options& column_mapping( // (since 1.2.0)
const std::vector<std::pair<std::string,std::string>>& value);
basic_csv_options& max_nesting_depth(std::size_t value); // (since 1.2.0)
basic_json_options& nan_to_str(const string_type& value, bool enable_inverse = true);
basic_json_options& inf_to_str(const string_type& value, bool enable_inverse = true);
basic_json_options& neginf_to_str(const string_type& value, bool enable_inverse = true); (4)
basic_json_options& nan_to_num(const string_type& value);
basic_json_options& inf_to_num(const string_type& value);
basic_json_options& neginf_to_num(const string_type& value);
basic_csv_options& float_format(float_chars_format value);
basic_csv_options& precision(int8_t value);
basic_csv_options& header_lines(std::size_t value);
basic_csv_options& assume_header(bool value);
basic_csv_options& ignore_empty_values(bool value);
basic_csv_options& ignore_empty_lines(bool value);
basic_csv_options& trim_leading(bool value);
basic_csv_options& trim_trailing(bool value);
basic_csv_options& trim(bool value);
basic_csv_options& trim_leading_inside_quotes(bool value);
basic_csv_options& trim_trailing_inside_quotes(bool value);
basic_csv_options& trim_inside_quotes(bool value);
basic_csv_options& unquoted_empty_value_is_null(bool value);
basic_csv_options& column_names(const string_type& value);
basic_csv_options& column_types(const string_type& value);
basic_csv_options& column_defaults(const string_type& value);
basic_csv_options& field_delimiter(char_type value);
basic_csv_options& subfield_delimiter(char_type value);
basic_csv_options& line_delimiter(string_type value);
basic_csv_options& quote_char(char_type value);
basic_csv_options& infer_types(bool value);
basic_csv_options& lossless_number(bool value);
basic_csv_options& quote_escape_char(char_type value);
basic_csv_options& comment_starter(char_type value);
basic_csv_options& quote_style(quote_style_kind value);
basic_csv_options& mapping_kind(csv_mapping_kind value);
basic_csv_options& max_lines(std::size_t value);
### Examples
#### Nested JSON to CSV
```cpp
#include <jsoncons/json.hpp>
#include <jsoncons_ext/csv/csv.hpp>
namespace csv = jsoncons::csv;
int main()
{
std::string jtext = R"(
[
{
"text": "Chicago Reader",
"float": 1.0,
"datetime": "1971-01-01T04:14:00",
"boolean": true,
"nested": {
"time": "04:14:00",
"nested": {
"date": "1971-01-01",
"integer": 40
}
}
},
{
"text": "Chicago Sun-Times",
"float": 1.27,
"datetime": "1948-01-01T14:57:13",
"boolean": true,
"nested": {
"time": "14:57:13",
"nested": {
"date": "1948-01-01",
"integer": 63
}
}
}
]
)";
auto j = jsoncons::json::parse(jtext);
auto options = csv::csv_options{}
.flat(false);
std::string buf;
csv::encode_csv(j, buf, options);
std::cout << buf << "\n";
}
```
Output:
```
/boolean,/datetime,/float,/nested/nested/date,/nested/nested/integer,/nested/time,/text
true,1971-01-01T04:14:00,1.0,1971-01-01,40,04:14:00,Chicago Reader
true,1948-01-01T14:57:13,1.27,1948-01-01,63,14:57:13,Chicago Sun-Times
```
|
