Multiple lines in output tables (pprint or omd)

[iskeld]

Hello,
When the input entry the default behaviour "breaks" the table by outputting the new line directly instead of putting the new lines in each cell.

mlr --json --opprint --barred cat file.json

+---------------------+----------+------------------------------------------------------------------------------------------------------------------------+
| Name                | Hours    | Description                                                                                                            |
+---------------------+----------+------------------------------------------------------------------------------------------------------------------------+
| Dean Deantempnam    | 4.000000 | row1
row2
row3
row4 |
| Temp Name           | 4.000000 | Singlerow
+---------------------+----------+------------------------------------------------------------------------------------------------------------------------+

I would like the first row to be formatted like that:

| Dean Deantempnam    | 4.000000 | row1  |
                                       |                   | row2 |
                                       |                   | row3 |
                                       |                   | row4 |

Is it possible ?

[aborruso]

Could you share a sample input json file?

[iskeld]

Here's the input

  {
    "Name": "Kelly Kapoor",
    "Hours": 4.000000,
    "Description": "Learning new stuff\nPhone calls\nCertificate training\nAccounting and stuff"
  },
  {
    "Name": "Dwight Shrute",
    "Hours": 4.000000,
    "Description": "Lorem ipsum lorem ispum"
  },
  {
    "Name": "Michael Scott",
    "Hours": 3.500000,
    "Description": "TEST certification\nTEST certification\nHow to use Memes with AI: workshop \nManager certification"
  },
  {
    "Name": "Pam Beasley",
    "Hours": 4.000000,
    "Description": "XMas part \nPhone calls"
  },
  {
    "Name": "Kevin Malone",
    "Hours": 4.000000,
    "Description": "Eating candies"
  }
]

Which outputs something like that

❯ mlr --json --opprint --barred cat myfile.json
+---------------+----------+-------------------------------------------------------------------------------------------------+
| Name          | Hours    | Description                                                                                     |
+---------------+----------+-------------------------------------------------------------------------------------------------+
| Kelly Kapoor  | 4.000000 | Learning new stuff
Phone calls
Certificate training
Accounting and stuff                        |
| Dwight Shrute | 4.000000 | Lorem ipsum lorem ispum                                                                         |
| Michael Scott | 3.500000 | TEST certification
TEST certification
How to use Memes with AI: workshop
Manager certification |
| Pam Beasley   | 4.000000 | XMas part
Phone calls                                                                          |
| Kevin Malone  | 4.000000 | Eating candies                                                                                  |
+---------------+----------+-------------------------------------------------------------------------------------------------+

As you can see the table is "broken" beacause of the newlines. I would like the first to columns to be expanded vertically to make space for additional lines in the third column

[johnkerl]

@iskeld this would be a great feature to have.

Some of Miller's output file formats handle/escape nested delimiters (CSV, TSV, JSON) and some don't (XTAB, PPRINT, MARKDOWN).