如何在以下条件下基于逗号终止CSV [英] How to terminate CSV based on comma in below condition

问题描述

如何在以下条件下根据逗号终止CSV？

How to terminate CSV based on comma in below condition?

Column1,Column2,Column3,Column4,Column5,Column6
AB,"I,am,ABC",100.25,"Description, can, contain. multiple: comma;","http://dnl.cashdownload.com/dd/OKOKOKOKO",Hello

推荐答案

这很复杂，但有很多方法可以让它变得更容易。我更喜欢这个：快速CSV阅读器 [ ^ ] - 它完成了它所说的内容！

It's complicated, but there are a lot of ways to make it easier. I prefer this one: A Fast CSV Reader[^] - it does what it says!

用另一个char替换子字符串中的逗号 - 在写入之前和阅读CSV文件之后也是如此

Replace the comma inside the sub-strings by another char - before writing AND ALSO after reading the CSV-file

这篇关于如何在以下条件下基于逗号终止CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！