Hi,
How to remove junk characters in flat file using sql.
How to remove junk characters in flat file using sql.
[FONT=Lucida Console]select regexp_replace( ' abcdefghijklmnopqrstuvwxyz01234567890`~!@#$%^&*()-_=+[{]}\|;:''",<.>/?' --replace this parameter with your source data to be converted ,'[[^a-z]&&[^0-9]&&[^\s`~!@#\$%\^&\*\(\)-_=\+\[\{\]\}\\\|;:''",<\.>/\?]]' ,'', 1, 0, 'i' ) from ( values( 1 ) ) as T[/FONT]
Comment