Question

In a malformed .csv file, there is a row of data with extra double quotes, e.g. the last line:

Name,Comment
"Peter","Nice singer"
"Paul","Love "folk" songs"

How can I remove the double quotes around folk and replace the string as:

Name,Comment
"Peter","Nice singer"
"Paul","Love _folk_ songs"

Answer 1

在Rub.1.9,以下著作:

result = subject.gsub(/(?<!^|,)"(?!,|$)/,  _ )

Previous versions don t have lookbehind assertions.

<>Explanation:

(?<!^|,)  # Assert that we re not at the start of the line or right after a comma
"         # Match a quote
(?!,|$)   # Assert that we re not at the end of the line or right before a comma

当然,这假定,我们赢得了像病理学一样的 t。

"Mary",""Oh," she said"

Answer 2

如果你没有在Rub.1.9上台,或者仅仅退休,有时会把座标分为<代码>,,删除第一种/最后报价,将剩余的<代码><>><>>>>/代码改为_s,re-quote,并加入,。

页: 1 必须担心效率!

Answer 3

$str =  "folk" ;

$new = str_replace( " ,   , $str);

/* now $new is only folk, without " */

Answer 4

元战略:

It s likely the case that the data was manually entered inconsistently, CSV s get messy when people manually enter either field terminators (double quote) or separators (comma) into the field itself. If you can have the file regenerated, ask them to use an extremely unlikely field begin/end marker, like 5 tilde s (~~~~~), and then you can split on "~~~~~,~~~~~" and get the correct number of fields every time.

Answer 5

除非你别无选择,否则,档案就会以正确的方式重新生成。任何其他做法都要求引起麻烦,因为插入令人不安的替罪状是损失的,因此无法得到可靠的逆转。

如果你能够从来文方那里找到档案,那么Tim Pietzcker的reg子比任何东西都好,但我强烈建议你用你的文字打印所有“固定”线,并用人工核对错误。

友情链接