Source file correction

raju4u · Post by **raju4u** » Tue Mar 12, 2013 2:41 am

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..

chulett · Post by **chulett** » Tue Mar 12, 2013 7:40 am

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.

sudha03_vpr · Post by **sudha03_vpr** » Tue Mar 12, 2013 4:16 pm

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 ?