HI,

I am trying to find a way to load the file i have with two columns in it namely end customer name and short name to oracle table without any special character

in end customer name.

What is the function i need to be using inorder to load the data without any special characters.

Thanks

Deepak.

7.7.03

If the number of special characters that appear are consistent and limited in number, you could use function STRIP to remove them, or functions STRREP/CTRAN to replace them with another character (e.g., space). You would need to apply STRIP or STRREP/CTRAN for each individual character that might appear in the string. That's why this approach is best suited for a limited number of special characters.

hi Dan,

Could you please provide the syntax of strip function and how to use it with trimv function.i am new to data migrator.thanks in advance.

Documentation for all of IBI's tools can be found at http://documentation.informationbuilders.com.

Here is a link to the HTML version of the functions manual:

http://documentation.informati...3/function/index.htm