Resolved Insert end of line with replace rule

Hi,

No need to apply the patch again, I will include this in the next release together with a fix for not using multiple values.

I have tried with regular expression method, Text to find: /~/ Replace with: \r\n
and i get this:
Status error: 500
Status message: error
{"error":true,"code":0,"message":"PlgCsvirulesMultireplace::delimiterEscapeSequence(): Argument #1 ($delimiter) must be of type array, string given, called in \/var\/www\/vhosts\/mydomain.com\/httpdocs\/plugins\/csvirules\/multireplace\/multireplace.php on line 254"}

Also tried with /\r\n/ or "\r\n" or "/\r\n/"

Hi,

Did you try something already? You are going to need to create replacement rule of the type regex where you look for the /~/ and replace it with \r\n That should be enough to make it work.

Let us know how it goes.

Yes i tried several combinations for the replace. It always outputs \r\n as text inside the csv.

My settings in Separator options of the template are
Category Separator /
Values Separator ^
Item Separator $
Fields Separator ~
Nested Values Separator #

Hello,
You need to use RO CSVI Multi replace rule to find ~ and replace with \r\n. As Roland mentioned you can use regular expression in Multi replace rule to do the replacement.

Hello, this is i am doing but it doesnt work. In the replace field \r\n\ is not recognized as special character but as text. The same with regex, i have tried /\r\n/ too, /[\r\n]/.

Hello,
Please share export template XML to check. To get the template XML file from RO CSVI templates list page select the export template and click on Backup templates button. Post the downloaded XML file. I will check the rule from your template.

See attachement, thanks

Let me explain what i am trying to do.
I am exporting values from content joomla custom fields. Some fields are Subform type and have multiple values separated by ~. So i try to put these values in a separate line as if they were from different articles.
Ex.
field1_value1.1^field1_value1.2^field1_value1.3^field1_value1.4^field1_value1.5^field1_value1.6^field1_value1.7~field1_value2.1^field1_value2.2^field1_value2.3^field1_value2.4^field1_value2.5^field1_value2.6^field1_value2.7^field2_value1.1^field2_value1.2^field3_value1^title^modified^modified_by_name^modified_by

Desired result:
field1_value1.1^field1_value1.2^field1_value1.3^field1_value1.4^field1_value1.5^field1_value1.6^field1_value1.7
field1_value2.1^field1_value2.2^field1_value2.3^field1_value2.4^field1_value2.5^field1_value2.6^field1_value2.7^field2_value1.1^field2_value1.2^field3_value1^title^modified^modified_by_name^modified_by

In the file attached is the template with the rule to replace ~ with \r\n but doesn t work.

Hi,

In your replacement rule, set the Multiple values to Yes and let me know how that goes. That is how I tested it.

Ok, that worked, thank you!
Do i have to apply this patch again when i update to new versions?