Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Replacing \n with carriage returns

Topic Labels: Formulas
270 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rahum
4 - Data Explorer
4 - Data Explorer

Hi all, I am importing JSON into Airtable and parsing it into fields using REG_EXTRACT.

Some of the JSON data are blocks of text that have "\n" (without the quotes) in place of carriage returns. Airtable treats the \n as text rather than carriage returns in the output of the REG_EXTRACT function.

How can I replace the \n text characters with actual carriage returns?

1 Reply 1

Try this:

 

SUBSTITUTE({Name}, "\\n", "\n")

Screenshot 2024-11-13 at 11.10.06 PM.png