Regex tester
Pattern
Input
,record1 value2 test,val3,"value 4","testing ""embedded double quotes""","testing quoted "","" character", value 7,, value 9,"testing empty """" embedded quotes","testing a quoted value

that includes CR\LF patterns

(which we wish would never happen - but it does)", after CR/LF,"testing open ended quote

,record2 value 1 test,value 2 test,5
"test"
Options
Replacement
Click the context tab to see replacements.
2 matches found in about 2 milliseconds.
IndexPositionMatched String${Value}${OpenValue}
00,record1 value2 test,val3,"value 4","testing ""embedded double quotes""","testing quoted "","" character", value 7,, value 9,"testing empty """" embedded quotes","testing a quoted value

that includes CR\LF patterns

(which we wish would never happen - but it does)", after CR/LF,"testing open ended quote

,record2 value 1 test,value 2 test,5
after CR/LF
12 captures
  1. empty string
  2. record1 value2 test
  3. val3
  4. value 4
  5. testing ""embedded double quotes""
  6. testing quoted "","" character
  7. value 7
  8. empty string
  9. value 9
  10. testing empty """" embedded quotes
  11. testing a quoted value

    that includes CR\LF patterns

    (which we wish would never happen - but it does)
  12. after CR/LF
testing open ended quote

,record2 value 1 test,value 2 test,5
1351"test"testempty string
,record1 value2 test,val3,"value 4","testing ""embedded double quotes""","testing quoted "","" character", value 7,, value 9,"testing empty """" embedded quotes","testing a quoted value
​
​that includes CR\LF patterns
​
​(which we wish would never happen - but it does)", after CR/LF,"testing open ended quote
​
​,record2 value 1 test,value 2 test,5
​"test"
  1. empty string
  2. after CR/LF
  3. testing open ended quote

    ,record2 value 1 test,value 2 test,5
  4. empty string
  5. test
  6. empty string