Powershell script to remove double quotes from CSV unless comma exists inside double quotes

by

Adapting the code from “How to remove double quotes on specific column from CSV file using Powershell script”:

$csv = 'C:\path\to\your.csv'
(Get-Content $csv) -replace '(?m)"([^,]*?)"(?=,|$)', '$1' |
    Set-Content $csv

The regex (?m)"([^,]*?)"(?=,|$) is matching any " + 0 or more non-commas + " before a comma or end of line (achieved with a positive look-ahead and a multiline option (?m) that forces $ to match a newline, not just the end of string).

See regex demo

More Related Contents:

  1. PowerShell expression
  2. Regex to split a CSV
  3. Regex for Comma delimited list
  4. powershell: how to escape all regex characters from a string
  5. Multiline regex to match config block
  6. Use a function in Powershell replace
  7. Split text by columns in PowerShell
  8. Find numbers after specific text in a string with RegEx
  9. How can I parse quoted CSV in Perl with a regex?
  10. How to capture multiple regex matches, from a single line, into the $matches magic variable in Powershell?
  11. powershell extract text between two strings
  12. Multiline Regex in PowerShell
  13. string pattern matching using perl regex [closed]
  14. Why is this regex allowing a caret?
  15. Regex: ignore case sensitivity
  16. Decimal or numeric values in regular expression validation
  17. Carets in Regular Expressions
  18. How do you debug a regex? [closed]
  19. Negating a backreference in Regular Expressions
  20. Regex to split HTML tags
  21. Export hashtable to CSV with the key as the column heading
  22. R/regex with stringi/ICU: why is a ‘+’ considered a non-[:punct:] character?
  23. Can someone explain Possessive Quantifiers to me? (Regular Expressions)
  24. Regular expression help – comma delimited string
  25. Convert to lowercase in a mod_rewrite rule
  26. Add Column to CSV Windows PowerShell
  27. What kind of formal languages can modern regex engines parse?
  28. Regular expressions Equivalence
  29. Regex BNF Grammar
  30. Get Twitter @Username with Regex in R

Leave a Comment