Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jul 05, 2022 10:36 PM
This is driving me nuts. I have a long text field (rich text turned off) that seems to have multiple line breaks.
Formula I used was Substitute(Field,“\n”,“”) and while it seems to work it also doesn’t. I tried with putting in a value instead of “” so I could see it working and it is working but also airtable seems to be keeping paragraphs anyway.
Any help would be greatly appreciated.
Solved! Go to Solution.
Jul 06, 2022 01:09 PM
Ok I seem to have stumbled onto the solution substitute does not work for \r removal which I had tried already only regex_replace works but only on the original text column not if it is a lookup column.
REGEX_REPLACE(REGEX_REPLACE(Field,“\n”,“”),“\r”,“”)
Jul 05, 2022 11:00 PM
Hi Brent, hmm, so you’ve got a long text field, and you’re trying to strip all the new lines out of it, right?
Could you have a look at this base and tell me where our setups differ? I was attempting to replicate your issue but couldn’t get it to happen, so I think I’m setting it up wrong
Jul 06, 2022 01:09 PM
Ok I seem to have stumbled onto the solution substitute does not work for \r removal which I had tried already only regex_replace works but only on the original text column not if it is a lookup column.
REGEX_REPLACE(REGEX_REPLACE(Field,“\n”,“”),“\r”,“”)