Quite intriguing I must admit. Found this on the Google Gods
All 3 of them represent the end of a line. But…
\r(Carriage Return) → moves the cursor to the beginning of the line without advancing to the next line
\n(Line Feed) → moves the cursor down to the next line without returning to the beginning of the line *— In a nix environment
\nmoves to the beginning of the line.
\r\n(End Of Line) → a combination of
What is known about the Integromat integration? What’s it connected to and what’s their application?
“Inquiring minds want to know” :nerd_face:
Thank you for your reply.
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.