RegExLib.com - The first Regular Expression Library on the Web!

A regex that will split a CSV file when used for MATCH function. All values must be in quotes, and seperated by commas. Ex. "test1","test2","test3" Quotes themselves are not captured Note: Only works in regex engines that support backreferences (Java, .NET, php, etc). JavaScript is not one of them.

Use for parsing CSV files exported from MS Excel, This program adds or not quotes, so it's more complicated.. Use for parsing individual lines, the Regex doesn't capture end of line (supposed to ($) but not made it in the testing so you cannot parse the whole file. Read a line and split it, with this regex

Very simple (but very useful!) regex to split CSV files. It does not drop the commas - you have to do that manually. Quotes are dealt with properly and escaped quotes are ignored. Matches from sample:this is ;a;"line,\"in\"a";csv;file

Parse CSV. First You need add to begin and to end of every line comma. Example. You need to get line like ,test,"test1",..., "testN", .And after You can parse line.

Allows a file with the format <drive><directory>yyyy-mm-dd-DailyUpload.csv

This expressions parses one line from a CSV file which has been written with Excel. It does cover all variants: simple value, value masked by double quotes (including semicolons between double quotes which don't count) and double quotes masked by double quotes (""). Replace all semicolons within the regex to change the separator character.

I started out looking for a way to propertly parse delimited CSV text. Everything that I tried on my own was not doing what I wanted it to do, so I borrowed one from someone here and customized it a bit to get pretty close to what I wanted (see ORIGIONAL MESSAGE below). Ultimately though, I still needed more functionality, so I started over, and came up with this. It actually does a very good job of actually parsing columns from the CSV text. I use Regex Replace( csvText, "[$1$2]" ) to actually see the column content, but there are many other ways (obviously). ORIGIONAL MESSAGE: ____________________________________________________ I was having trouble parsing fields from csv files due to the string qualifiers, when I came across a regex posted by Tom Svensson. It didn't quite meet my needs though because it was parsing the substrings (escaped quotes) as seperate results. This one will actually parse the entire string out, with it's escaped quote portion. None the less, thank you Tom Svensson for your help!

This pattern validates a 3 field CSV file. I designed it to capture first name, last name and email address in that order.

This will match fields in a row of a csv file. Values can be double quoted or not. If a value is double quoted it can have commas inside it. Each value will be captured to word.

Accepts a list of 4 digits separated by commas. Used to validate a list of years. Can be easily customized to change the number of digits.

Returns the value from a CSV line.

Parses comma-separated numbers. Doesn't allow spaces inbetween numbers and/or between numbers and commas. Allows single number to be added. Doesn't allow sequence to end with a comma.

This will match with all absolute file paths in Unix/Linux. The extensions added are csv|jpg|txt|pdf|dat|xls|doc. Can be customized for specific extensions.

I had a CSV file with following format: book,chapter,verse_start,verse_end,notes I wanted to transform the rows to traditional english verse representations (i.e. "1 Timothy 2:2-4") Unfortunately, this regex always puts a '-' after the verse_start, so if verse_end is empty, the translated version will have a trailing '-'. Vim needs everything escaped, so here is the actual vim command for the substitution: :%s/\(\d\?\s\?\w\+\),\(\d\+\),\(\d\+\),\(\d*\),/\1 \2:\3-\4/g