4 ms·
I assume there’s a row or column that this applies to in their sheet. So I’m suggesting instead of having some regex applies to check the values. Just setting t
by philliphaydon 4y ago
I assume there’s a row or column that this applies to in their sheet. So I’m suggesting instead of having some regex applies to check the values. Just setting the entire row or column to text would resolve the issue.
- charcircuit 4y agoWhen he says "various google sheets" it sounds like new ones are occasionally created so you would have to do that each time a new one is created. It's extra friction which you can easily avoid.
- philliphaydon 4y agoBut he’s putting a regex into the sheet? Unless he has some tool to look at the spreadsheets in gdrive and applies the regex to them? Guess we lack info from the OP.
- egypturnash 4y agoThe regex goes into their UUID generation routine, to stop it from ever generating another UUID with an E in the middle.