Re: Substitute paragraph breaks?

867 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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

1 Reply 1

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…