Regex
Some Regex syntax
Find quoted text "(.*?)" Lookahead: matches “x” only if “x” is followed by “y” x(?=y) Negative lookahead: matches “x” only if “x” is NOT followed by “y” x(?!y) Lookbehind: matches “x” only if “x” is preceded by “y” (?=y)x Negative lookbehind: matches “x” only if “x” is NOT preceded by “y” (?!y)x CSV file line columns counts Using comma as delimiter.
,|(".*?"(,(?!$))?) break above down as:
, a standard comma | or ( start of group ".
Posted by John Liu Saturday, November 27, 2021