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
- Go to Replacement
- 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
- 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:
- Go to Replacement
- 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
- Do an import of your template