Support for Newline Character in Template Column Replacements

[Alexey_Khrolovich]

Hi Glide Community,

When using the “Replacements” feature in the Template column, there’s no way to target a newline character.

The Use Case:
A very common task is cleaning up multi-line text fields before using them in other constructs. For instance, when building a JSON object, any line breaks in a text value will make the entire JSON invalid. We need an easy way to replace these line breaks with a space.

The most intuitive and user-friendly solution would be to allow users to physically press the ‘Enter’ key inside the “Find” input box to create a line break character.

[Darren_Murphy]

@Alexey_Khrolovich

A very common task is cleaning up multi-line text fields before using them in other constructs. For instance, when building a JSON object, any line breaks in a text value will make the entire JSON invalid.

If that’s your only use case, then the recommended approach is to use the native JSON columns (JSON Object/JSON Template). These will automatically deal with any unsupported characters and will always produce valid JSON.

[Alexey_Khrolovich]

thank you!