Help

Replacing \n with carriage returns

Topic Labels: Formulas
164 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