Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Getting rid of lines, line feeds, carriage returns, and paragraphs in a formula field

Topic Labels: Formulas
1036 0
cancel
Showing results for 
Search instead for 
Did you mean: 
SteelsmithHaus
6 - Interface Innovator
6 - Interface Innovator

For anyone that has been trying to get a formula field to ACTUALLY substitute line feeds, carriage returns, and paragraphs here is a solution I (slowly) figured out.

Use the following formula to URL encode the text, and then substitute the other stuff you do want back in. Despite all of the suggestions I saw in here, you can’t substitute the \n with anything because airtable just adds it back in.

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(ENCODE_URL_COMPONENT({Your Field}),"%20"," “),”%3F","?"),"%0D"," “),”%0A"," “),”%3A",":"),"%2F","/"),"%21","!"),"%2C",","),"%3B",";"),"%27","’")

If there are still some encoded characters showing up, just go here to grab it and wrap it again with another substitution.

If anyone has a better solution, lemme know.

DON’T SAY I NEVER DID ANYTHING FOR YOU!

0 Replies 0