Ignores/Strips CSV cell content when parsing CSV cells starting with "#"

[rrrix]

When parsing a CSV file that has a cell starting with the # character, it will set that cell to nil (or null).

Given the following CSV example:

Input CSV

"color","hex"
"white","#ffffff"
"black","#000000"
"red","#ff0000"
"green","#00ff00"
"blue","#0000ff"
"notblack","000000"
"kcalb","000000#"

Actual Behavior

Using yq to pretty print it right back as CSV:

$ yq . colors.csv

color,hex
white,
black,
red,
green,
blue,
notblack,000000
kcalb,000000#

Or to JSON:

$ yq -ojson . colors.csv

Click to expand...

[
  {
    "color": "white",
    "hex": null
  },
  {
    "color": "black",
    "hex": null
  },
  {
    "color": "red",
    "hex": null
  },
  {
    "color": "green",
    "hex": null
  },
  {
    "color": "blue",
    "hex": null
  },
  {
    "color": "notblack",
    "hex": 0
  },
  {
    "color": "kcalb",
    "hex": "000000#"
  }
]

Expected Behavior

Running yq . colors.csv should produce the output unchanged.

$ yq --version
yq (https://github.com/mikefarah/yq/) version v4.44.2
$ uname -sm
Darwin x86_64

Installed via Homebrew.

[mikefarah]

Thanks for raising, will fix in the next release.

Note that when fixed, you will likely want to pass in --csv-auto-parse=f because by default yq parses csv values, and the "#" symbol will be interpreted as a comment.

[mikefarah]

Fixed in 4.44.3