I have an Integromat scenario which will take a CSV file and once it’s parsed, it will place the data into Google Sheets. I was just not sure what this formula does. Especially the Empty String part and what do the numbers mean, might you know? I am afraid formulas are not quite my strong suit.
I often use that same phrase about inquiring minds, too. It was quite funny when I read it.
Thank you for checking this out for me. I appreciate it.
That formula uses what’s called a regular expression to (apparently) remove all carriage returns, line feeds, and end-of-line characters from the text. I only know a little about regular expressions, but they can be quite powerful tools for searching and manipulating data. Unfortunately Airtable doesn’t support them (yet), but it’s good to see that Integromat does.