DSXchange

Hi All,

i am extracting data from source file.Here i am getting some special character those are like some box characters... How can i remove those special characters from the file.

Can anybody help me on this...

Thanks..

First you need to identify those "special" characters. For that, a hex editor or a hex dump (od -h filename) can be helpful. Or even vi with ":set list" can help sometimes.

As said by Ray, Data viewers sometimes shows a special character but the data inserts into the table may not have that character.

Do you get any errors because of this special character when you insert the data into the table ?