Regex to remove any line breaks / special characters

Help Center Get Answers
1

Hi all,

I have a field where I am pasting in from excel a list of values (not comma separated) into a paragraph text field and I need to remove the hidden line breaks that are ‘included’ so my values go from a number of lines to one long string.

I can do it using an Excel Concat function but that would require the user to paste the values into a spreadsheet then into Knack. Similarly I can do it using Zapier / Integromat but I am looking for a solution in Knack.

So I’m trying to get from this:

image
image787×521 25.5 KB

To this:

image
image800×529 29.2 KB

I have tried using the Replace and regexReplace functions but can’t get it to work annoyingly.

Any suggestions?

Thanks a lot