October 19, 2012, 04:43 PMdeepak85
REGARDING REMOVING SPECIAL CHARACTERS IN DATAMIGRATOR WHILE LOADING DATA INTO ORACLE
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.
October 20, 2012, 03:49 PMDan Satchell
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.
October 22, 2012, 11:35 AMdeepak85
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.
October 22, 2012, 12:05 PMDan Satchell
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