0

This is not duplicate! I'm asking for solution with regex. I can't use external libraries

I have csv file with [,] as separator and ["] as escape character. I need regex to get all the "cells" from the row.

This row should be converted to:

This, Is, "Super Test", That, "Should, maybe work", Oh

1. This
2. Is
3. Super Test
4. That
5. Should, maybe work
6. Oh

I want to to be universal so I can't hardcode number of "cells".

Can you help me create regex for that?

What I tried? I tried creating regex but failed.

P.S. If you know other method that is nice or maybe faster I'd be happy to hear about it.

Improve this question
4
  • 1
    Use a CsvParser Commented Oct 9, 2014 at 13:40
  • 1
    Perhaps... csv parser c# Commented Oct 9, 2014 at 13:40
  • 1
    You've forgotten to include what you've tried already. Commented Oct 9, 2014 at 13:42
  • check this answer on the "duplicate" question stackoverflow.com/a/9935529/2390075 Commented Oct 10, 2014 at 9:51
Related questions
1165
Writing a pandas DataFrame to CSV file
1155
Save PL/pgSQL output from PostgreSQL to a CSV file
753
CSV file written with Python has blank lines between each row
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.