Skip to main content
Unix & Linux

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

3
  • Purely to satisfy my curiosity, we do a lot of csv stuff, never seen this type of problem, exactly why is this needed? are you going to split the comma separated quoted entries into some further thing? This is just curiosity, not a criticism of the question, I'd personally just like to know what scenario you have that makes this required, maybe to see if there isn't a better way to handle it in general. Commented Aug 1, 2016 at 21:22
  • I'm given a HTML output from a program ChimeraScan and have to convert that to CSV so that we can use it in R. Commented Aug 1, 2016 at 21:28
  • are the " enclosed commas , going to create further csv columns in the same row? or are they going to create sub rows, in a different dataset? it appears you won't know in some cells how many data points there are, so it has to be dynamic, which is challenging. I assume the , in any escaped item will then be used to a different data row, but one related to the primary row, like a db foreign key sort of. Commented Aug 1, 2016 at 21:33