CSV configuration used for creating CSVParser.

This config may be used as a builder to create a parser:

val parser = CSVConfig.fieldSizeLimit(1000).noHeader().get[IO]()

Field delimiter is ',' by default.

Record delimiter is '\n' by default. When the delimiter is line feed ('\n', ASCII 10) and it is preceded by carriage return ('\r', ASCII 13), they are treated as a single character.

Quotation mark is '"' by default. It is required to wrap special characters in quotes - field and record delimiters. Quotation mark in content may appear only inside quotation marks. It has to be doubled to be interpreted as part of actual data, not a control character. If a field starts or end with white character it has to be wrapped in quotation marks. In another case the white characters are stripped.

If the source has a header, which is the default, it is used as an keys to actual values and not included in data. If there is no header, a number-based keys are created (starting from "_1").

If CSV records are converted to case classes, header values are used as class fields and may require remapping. This can be achieved through mapHeader:

config.mapHeader(Map("first name" -> "firstName", "last name" -> "lastName")))

or if there is no header line:

config.mapHeader(Map("_1" -> "firstName", "_2" -> "lastName")))

Header mapping may be also position-based, which is especially handy when there are duplicates in header and name-based remapping does not solve it (because it remaps all occurrences):

config.mapHeader(Map(0 -> "firstName", 1 -> "lastName")))

Field size limit is used to stop processing input when it is significantly larger then expected and avoid OutOfMemoryError. This might happen if the source structure is invalid, e.g. the closing quotation mark is missing. There is no limit by default.