#ERROR using SUBSTITUTE()

[Melissa_Frank1]

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

[Jeremy_Oglesby]

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…