Focal Point
REGARDING REMOVING SPECIAL CHARACTERS IN DATAMIGRATOR WHILE LOADING DATA INTO ORACLE

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/3587013526

October 19, 2012, 04:43 PM
deepak85
REGARDING REMOVING SPECIAL CHARACTERS IN DATAMIGRATOR WHILE LOADING DATA INTO ORACLE
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


7703
Windows, Excel
October 20, 2012, 03:49 PM
Dan 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.


WebFOCUS 7.7.05
October 22, 2012, 11:35 AM
deepak85
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.


7703
Windows, Excel
October 22, 2012, 12:05 PM
Dan 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


WebFOCUS 7.7.05