Screen shot
Here is the screen shot, please note the CRLF character which results new line 20, 21, 22 and 23. This should be all in line 19.
Thank you
Labrat
Hi @labrat555
I hope you are doing good today.
As mentioned by you in your first reply, could you share a screenshot of this in google drive or dropbox so we could be on the same page when we will ask our Devs about this issue?
Kind Regards,
Kris
Hello @labrat555 !
I hope all is well.
I’ve seen this issue before with Excel (I think only Excel has this odd behaviour, as things such as Libre Office, Google Docs and Apple Pages worked well) and can confirm it exists, but it’s actually an Excel bug.
I’ve asked our Second Line Support team whether it would be possible to run a filter before exporting the CSV to replace the CR LFs with more correct \r\n. We’ll update you here as soon as we hear back from them.
Warm regards,
Pawel
Hello once again @labrat555 !
I trust you’re doing well today!
Our Second Line Support team has shared the following snippet you can use to change the CR LFs during export:
add_filter( 'forminator_entry_meta_value_to_string', function( $value ){
if( is_string( $value ) ){
// $value = preg_replace('~(*BSR_ANYCRLF)\R~', "\r\n", $value);
$value = preg_replace('~\R~u', "\r\n", $value);
}
return $value;
} );
You can add this snippet to your child theme’s functions.php (if you’re using a child theme, otherwise I don’t recommend doing that as an update will remove this snippet). Or you can place it in a .php file and add <?php at the start, in wp-content/mu-plugins. The filename can be anything, but it needs to be a .php file.
Warm regards,
Pawel
Hello @labrat555 ,
We haven’t heard from you for a while now, so it looks like you don’t have more questions for us.
Feel free to re-open this ticket if needed.
Kind regards
Kasia
