- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2019 01:48 PM
I am trying to add a formula field that replaces all spaces in a long text field with “+”, and all paragraph breaks with “\n”. How do I designate a paragraph break in a formula?
SUBSTITUTE(SUBSTITUTE({Event Details},’ ‘,’+’),< p >,’\n’) won’t even save, and if I put quotes around “< p >” it saves but of course doesn’t take out actual paragraph breaks. Same thing if I use \ n or %0A.
(I had to add spaces in < p > here, so the above paragraph wouldn’t split over 2 lines!)
Any suggestions would be greatly appreciated! Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2019 06:12 PM
Text fields in Airtable (or formula fields that output text) recognize \n as a new line character — so it may actually be the case that your substitution is taking place, but Airtable is converting the \n you sub in right back into a new line when it displays the result.
I know I have used \n many a time in formulas to produce a new line in concatenated text…