Replacement: remove last character

To drop the last character from a field you can use the Replacement feature of CSVI VirtueMart.

Since version 2.3.13.

Remove last character

1. Go to Replacement
2. Make a new entry with the following settings
   • Select the field you want to apply the rule to
   • Find: /(.*)([0-9])$/
   • Replace: $1
   • Type: Regular expression
   • Click on the Add icon
3. Do an import of your template

Remove several characters from the end

To remove 3 characters from the end of your data you can use these steps:

1. Go to Replacement
2. Make a new entry with the following settings
   • Select the field you want to apply the rule to
   • Find: /(.*)([0-9]{3})$/
   • Replace: $1
   • Type: Regular expression
   • Click on the Add icon
3. Do an import of your template