Regex for CSV split including multiple double quotes

Gruber Published at Dev

Gruber

I have a CSV column data containing text. Each row is separated with double quotes "

Sample text in a row is similar to this (notice: new lines and the spaces before each line are intended)

"Lorem ipsum dolor sit amet, 
 consectetur adipisicing elit, sed do eiusmod
 tempor incididunt ut labore et dolore magna 
 aliqua. Ut ""enim ad"" minim veniam,
 quis nostrud exercitation ullamco laboris nisi 
 ut aliquip ex ea commodo
 consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
 cillum dolore eu fugiat ""nulla pariatu"""
"ex ea commodo
 consequat. Duis aute irure ""dolor in"" reprehenderit 
 in voluptate velit esse
 cillum dolore eu fugiat nulla pariatur. 
 Excepteur sint occaecat cupidatat non
 proident, sunt in culpa qui officia deserunt 
 mollit anim id est laborum."

The above represent 2 subsequent rows.

I want to select as separated groups all the text contained between every first double quote " (starting a line) and every LAST double quote "

As you can see tho, there are line break in the text, along with subsequent escaped double quotes "" wich are part of the text that I need to select.

I came up with something like this

(?s)(?!")[^\s](.+?)(?=")

but the multiple double quotes are breaking my desired match

I'm a real novice with regex, so I think maybe I'm missing something very basic. Dunno if relevant but I'm using Sublime Text 3 so should be python I think.

What can I do to achieve what I need?

Wiktor Stribiżew

You can use the following regex:

"[^"]*(?:""[^"]*)*"

See demo

This regex will match either a non-quote, or 2 consequent double quotes inside double quotation marks.

How does it work? Let me share a graphics from debuggex.com:

With the regex, we match:

" - (1) - a literal quote
[^"]* - (2, 3) - 0 or more characters other than a quote (yes, including a newline, this is a negated character class), if there are none, then the regex searches for the final literal quote (6)
(?:""[^"]*)* - (4,5) - 0 or more sequences of:
- "" - (4) - double double quotation marks
- [^"]* - (5) - 0 or more characters other than a quote
" - (6) - the final literal quote.

This works faster than "(?:[^"]|"")*" (although yielding the same results), because the processing the former is linear, involving much less backtracking.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-23

Comments

0 comments

TOP Ranking

Article

Regex for CSV split including multiple double quotes

Regex for CSV split including multiple double quotes

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

pump.io port in URL

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

grouping by column variables and appending a new variable based on condition

Python Read Directory And Output to CSV

BigQuery - concatenate ignoring NULL

Angular 8. Unknown amount of http.get requests in array to call, must be sequential, what to use

Remove adjacent duplicates in linked list in C

Can a 32-bit antivirus program protect you from 64-bit threats

How to keep curl session alive between two php processes?

Limit number of characters in uitextview

Unable to use switch toggle for dark mode in material-ui

In C#, is there a way to create a List directly from an Array without copying?

Laravel getting value from another table using eloquent

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

MTKView Displaying Wide Gamut P3 Colorspace

Vector input in shiny R and then use it

Modify c# Windows Forms control library

SQL Server : are transaction locking table for other users?

When I click any button in my view page the form is submitted

Can you sort columns (horizontally) in Google Sheets?