Split string on commas but ignore commas within double-quotes?

by

Lasse is right; it’s a comma separated value file, so you should use the csv module. A brief example:

from csv import reader

# test
infile = ['A,B,C,"D12121",E,F,G,H,"I9,I8",J,K']
# real is probably like
# infile = open('filename', 'r')
# or use 'with open(...) as infile:' and indent the rest

for line in reader(infile):
    print line
# for the test input, prints
# ['A', 'B', 'C', 'D12121', 'E', 'F', 'G', 'H', 'I9,I8', 'J', 'K']

More Related Contents:

  1. Regex in Python and save in csv [closed]
  2. Split string on whitespace in Python [duplicate]
  3. Pandas split column into multiple columns by comma
  4. Split string based on regex
  5. How would I get everything before a : in a string Python
  6. Python regex: splitting on pattern match that is an empty string
  7. How to split a string by commas positioned outside of parenthesis?
  8. Split string at every position where an upper-case word starts
  9. Splitting a math expression string into tokens in Python
  10. Searching for IP addresses in a file
  11. How to write a python code which copies a unique column from an output file to a .csv file
  12. Escaping regex string
  13. Split a string by a delimiter in python
  14. Fast punctuation removal with pandas
  15. Skip the headers when editing a csv file using Python
  16. Python: How to match nested parentheses with regex?
  17. How do you validate a URL with a regular expression in Python?
  18. How to add a new column to a CSV file?
  19. Skip rows during csv import pandas
  20. Python CSV error: line contains NULL byte
  21. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  22. Find USA phone numbers in python script
  23. Pandas read csv file with float values results in weird rounding and decimal digits
  24. Find out how many times a regex matches in a string in Python
  25. How to Split Image Into Multiple Pieces in Python
  26. Why isn’t the regular expression’s “non-capturing” group working?
  27. Python Regular Expression Match All 5 Digit Numbers but None Larger
  28. Read .csv file from URL into Python 3.x – _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)
  29. Get data from Twitter using Tweepy and store in csv file
  30. start index at 1 for Pandas DataFrame

Leave a Comment