piannaf’s avatarpiannaf’s Twitter Archive—№ 3,824

  1. Well, this is unfortunate. Why would SPLIT, a text function, coerce text into numbers, especially when the "number" has leading 0s? This at least should be documented, and there should be an optional flag to let it guess the data type each element support.google.com/docs/thread/15681911/split-function-loses-leading-zeroes-any-workarounds?hl=en
    piannaf’s avatar Mood +2 🙂
    1. …in reply to @piannaf
      This is also unfortunate, but not completely unreasonable support.google.com/docs/answer/3093343?hl=en
      oh my god twitter doesn’t include alt text from images in their API
      Permalink piannaf’s avatar Mood 0
      1. …in reply to @piannaf
        I don't know who needs to hear this, but JOIN and CONCATENATE have a 50,000 character limit in Google Sheets This is the best (non-script) workaround I found stackoverflow.com/a/30092408
        Permalink piannaf’s avatar Mood +4 🙂