Special Char in Data file

Hi All,

I have a data file in UNIX which i am trying to load into Oracle table using Oracle SQL Loader.

The problem is, one of the filed contains special character (ex: Square). And due to this reason, my script fails.

Could you please let me know, how to identify which character is that?

Is there any command, by which i can remove those character or alteast identify it?

$ od -bc <datafile>

Will show the contents of the file concerned in ASCII and Octal.

Thge run:

$ man ascii

To find out more about the character concerned.

The tr(1) command can delete or replace the offending character.