In the import module in Axis you have the option to set up a search and replace function that will search through your import data for certain terms and replace with the correct terms of strings. Functions are saved to mappings and can be used on subsequent imports.
To set up a function follow these steps.
- When editing a mapping in the third column select the drop down list to Add a new function and give the function a name.
- In the column labeled Search For select the terms that are in your import data that you would like to replace. Then in the adjacent column labeled Replace With, type in the term that you would like to replace with, you can have multiple search and replace terms.
- Click OK and the function will be saved to that mapping. When done you will return to the preview pane the function will replace any matching terms prior to import.