Good day,
We have made a find and replace rule in RO CSVI for our virtuemart products export. We want all category names to be replaced by a certain number/code.
When we export the csv file now, we see none of the category names got replaced by a number. We did something wrong, but we are not sure what.
The categories all have a | symbol in their names somewhere. Maybe it doesn't work because by default the separator is |? Please see the attached screenshot.
Thank you very much in advance for looking into this!
Kind regards,
Gina
Hello Gina,
If your category names have the pipe-symbol ( | ) in them, you can set a different separator in the Separator field below the Replace box. For example you can use a semi-colon instead. Perhaps double-up but make sure the names match exactly and that there is no trailing space or tab after the Find value.
Let me know how it goes.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello RolandD,
Thank you so much for your quick reply! So far it works great. However, we have come across another difficulty now.
Is it possible to make a rule along the lines of.. "If this field contains 'this certain text' (even if 'this certain text' is only half of the value of the entire field), then replace the entire field with 'this new text'."?
Hope to hear from you soon again! Thank you so much in advance.
Kind regards,
Gina
Hello Gina,
You need to use RO CSVI Multi replace rule with Regular expression to find a certain text and replace it. The below regular expression will replace the whole sentence with "Replace text" when there is a word "test" in it. You can modify it to your need. See attached screenshot on how to use it in a rule.
/[A-Z][^\\.;]*(test)[^\\.;]*/
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.