Multi line strings are not pretty-printed properly

[MarcCoquand]

Prerequisites

• make sure you're are using the latest version by csvtk version
• read the usage

Version is 0.30

Describe your issue

If you have a csv with multi-line strings and want to pretty print it, the rendering
is not what is expected.

For example

some,example,here
string1,"multiline
string",string2
more, text,"here
it overflows"
more,data,here

gets shown as

$ cat test2.csv | csvtk pretty -S grid
+---------+------------------+-------------+
| some    | example          | here        |
+=========+==================+=============+
| string1 | multiline
string  | string2     |
+---------+------------------+-------------+
| more    |  text            | here
it overflows  |
+---------+------------------+-------------+
| more    | data             | here        |
+---------+------------------+-------------+

whereas I think the multi-line text should be rendered within their respective column (like in excel and csvlens).

Here is kinda what I would expect it to look like (except the padding is a bit off):

+---------+------------------+-------------+
| some    | example          | here        |
+=========+==================+=============+
| string1 | multiline        | string2     |
|         | string           |             |
+---------+------------------+-------------+
| more    |  text            | here        |
|         |                  | it overflows|
+---------+------------------+-------------+
| more    | data             | here        |
+---------+------------------+-------------+

This is tested with the default, plain and grid format, but I suspect it applies to all formats.

[shenwei356]

Yes, it's not supported.

[shenwei356]

I convert "\n" and other symbols to " ". Available at https://github.com/shenwei356/csvtk/releases/tag/v0.32.0 .

See the convert table here: https://github.com/shenwei356/stable/blob/v0.2.0/table.go#L57-L65

$ cat test2.csv | csvtk pretty -S grid
+---------+------------------+-------------------+
| some    | example          | here              |
+=========+==================+===================+
| string1 | multiline string | string2           |
+---------+------------------+-------------------+
| more    |  text            | here it overflows |
+---------+------------------+-------------------+
| more    | data             | here              |
+---------+------------------+-------------------+

And you can set the max and min width for each column.

$  cat test2.csv | csvtk pretty -S grid -w 10 -W 0,15,15
+------------+-----------------+-----------------+
| some       | example         | here            |
+============+=================+=================+
| string1    | multiline       | string2         |
|            | string          |                 |
+------------+-----------------+-----------------+
| more       |  text           | here it         |
|            |                 | overflows       |
+------------+-----------------+-----------------+
| more       | data            | here            |
+------------+-----------------+-----------------+