Buono Estente

the bot has a day off.

Iterluarit (Greenlandic)

Have a nice holiday Mr.Borkbot :robot_face:

finally had the chance to put the good babashka to use!

I'm usually well versed with bash, but not so much with awk / perl wizardry. I had a misformed CSV file which didn't quote columns when the value itself contained the separator. the number of columns of each entry was known, so I had to surround the first TOTAL_COLUMNS - EXPECTED_COLUMNS when TOTAL_COLUMNS > EXPECTED_COLUMNS

spent about 10m looking for pure-bash solutions

then concocted a bb script and lived happily ever after 🙂

(I'd still be curious if you guys could come up with a native non-clj approach :P)

Great to hear 🙂

Cool, can I see the script? It seems like it'd be a nice reference.

sure

this last version has the extra addition of changing the separator to semicolon to make the Excel of my colleagues happier

(for [line *in*]
  (let [pieces (str/split line #"," -1)]
    (if (>= 11 (count pieces))
      (str/replace line "," ";")
      (let [[first-pieces other-pieces] (split-at (- (count pieces) 10) pieces)
            first                       (str \" (str/join "," first-pieces) \")]
        (str/join ";" (into [first] other-pieces))))))

aptly named fix-s***.bb

I love it.