Categories
View Replies (3)

Resolved RO CSVI find and replace help

  1. sergio0187
    sergio0187
  2. RO CSVI
  3. Friday, 09 July 2021
  4.  Subscribe via email
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
Attachments (1)
find-and-replace.png find-and-replace.png
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
sergio0187
sergio0187
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
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)[^\\.;]*/
Attachments (1)
Screenshot 2021-07-16 at 8.57.40 PM.png Screenshot 2021-07-16 at 8.57.40 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!