How may I apply double quotes around every value of csv file using TextMate?

regex csv textmate
Brad picture Brad · Aug 24, 2010 · Viewed 23.4k times · Source

I have a csv file with the following format:

example csv:

bear,brown,mean,large
ant,black,strong,tiny
cat,yellow,moody,small

How may I apply double quotes around every value? How may I accomplish this using regex?

I am using TextMate (text editor) to do the find/replace w/ regular expression.

Answer

Merlyn Morgan-Graham picture Merlyn Morgan-Graham · Aug 24, 2010

Here are the important portions of the regex. Hopefully I got it right when I converted to textmate format:

Search - ([^,]*)(,|$)

Replace - "$1"$2

Search explanation: Find every character that is not a comma, up until we reach a comma, or the end of the line. Capture the match for string to be quoted in one variable, and capture the comma/end-of-line match in another variable.

Replace explanation: The original string, quoted, and the comma or end-of-line that follows it.

Related questions

How to escape comma and double quote at same time for CSV file?

I am writing a Java app to export data from Oracle to csv file Unfortunately the content of data may quite tricky. Still comma is the deliminator, but some data on a row could be like this: | ID | FN | LN | …

Read More
Regex for Comma delimited list

What is the regular expression to validate a comma delimited list like this one: 12365, 45236, 458, 1, 99996332, ......

Read More
Regex to split a CSV

I know this (or similar) has been asked many times but having tried out numerous possibilities I've not been able to find a a regex that works 100%. I've got a CSV file and I'm trying to split it into an …

Read More