REMOVE SPECIAL CHARACTERS USING MLOAD

General

REMOVE SPECIAL CHARACTERS USING MLOAD

Hi Team, 

            Can you please guide me, how can we remove the Special Characters using mload script

Special Characters (¿ Ã Â � Ó Ø)  , I want to replace it with space...

Ex: i/p :  A¿B

 o/p: A B

Sample Mload Script :

.Layout InputFileLayout;

.Field Col1 * VARCHAR(1000);

.Field Col2 * VARCHAR(1000);

.Field Col3 * VARCHAR(1000);

.DML Label upsertDML;

insert Table_Name (

Col1,

Col2,

Col3

 ) VALUES (

:Col1,

:Col2,

:Col3

);