linux - 如何在csv中将列的所有数据放在一行中

Question

我有一个 csv 文件，它有 2 列 id，notetext。在第二列(notetext)中，数据来自多行。我想要的是将所有数据放在一行中。

这是示例:

**catalog_SID, Note_Text**
584,"Sample in a Glove Bag only.  Refer to SOP
489-701 for sampling
great
procedure."
647,"Do not use
hotplate"
680,Sample in a Glove Bag

我需要的是注释文本中的所有数据，如下所示:

**catalog_SID, Note_Text**
584,"Sample in a Glove Bag only.Refer to SOP 489-701 for sampling."
647,"Do not use hotplate"
680,Sample in a Glove Bag

知道如何实现吗？

Answer 1

只需读取整个文件，如果换行符后面没有数字和逗号，则用空格替换所有换行符

perl -0777 -pe's/\n(?!\d+,)/ /g' myfile

输出

catalog_SID, Note_Text
584,"Sample in a Glove Bag only.  Refer to SOP 489-701 for sampling great procedure."
647,"Do not use hotplate"
680,Sample in a Glove Bag