Prevent or delete CR from user input (carriage return)

[Ralf]

What is the best way to handle this?

[ThinhDinh]

No native way to prevent it, you might be able to prompt your way to an entry like that using the Custom component though.

Or you can use a JavaScript function to clean the carriage returns from a string, something like.

return p1.replace(/[\r\n]+/g, '')

Which means replacing all carriage returns and line feed/newline (I assume you might not want those as well) with an empty string.

[Ralf]

Thank you, I used REGEXREPLACE(B2:B;“/[\r\n]+/g”;“”) as arrayformula in Google Sheets.

[Himaladin]

It might be cleaner to handle this in a Glide JavaScript column instead of Google Sheets, since it avoids cross-platform dependency and keeps the logic closer to the app.

[Ralf]

I am not familiar with Glide Javascript, would this be appropriate?

if (!p1) return “”; return p1.toString().replace(/\r|\n/g, ‘’).trim();

The REGEX solution will clean up old line breaks, This will prevent new, thank you!