Replace line-break by space in textarea

Question

How to replace a line-break in the textarea by a <br>.
When the table is imported in Excel, I want all the line-breaks in the textarea be replaced by a space.
Otherwise all content will be spread over different rows in Excel.

I could manage in the older versions of CF but wondering how to do it in CF5.

Thanks in advance,

Tico

GreyHead · Accepted Answer

Hi Tico,

That option is still there in the CFv5 version of my action - PM me if you want to try a copy,

With the standard action I'd use a Custom Code action before the Export action and convert the textarea data.

<?php
$textareas = array(
  'textarea1',
  . . .
);
foreach( $textareas as $t ) {
  $form->data[$t] = nl2br($form->data[$t]);
}
?>

Add the names of the textareas you want to edit in the array.

You can also do this in the form On Submit event before the data is saved if that helps.

Bob

Forums

Replace line-break by space in textarea