Shell Programming and Scripting

Oracle can open the file but shows null data in all the rows but when taking the length of the column then it shows there is indeed some data which looks like non printable data.

some magic happens when i copy the content into different file by selection all the data from original file.

Out team has agreed to do copy form origianl file and pput it in another file before processing.

so all i want is to read line by line from original file and write in new file line by line.

So you opened the file with notepad and saved from notepad as a .txt ? In which case RudiC may hit the pin: opening with notepad will automatically convert the content and more remove some encoding is doesnt like, I have from time to time some trouble with file utilizing different encoding, so I have writen scripts to convert to what I need, e.g. I get a file in UTF-8, only I need iso-8859-1...

You need to know what encoding is used for your file, then what is used on your box, then look at the iconv man pages for a start

Is there any way to get what encoding is been used

What be the result of applying the file command? On my system with some playing around:

Code:

file file?
file~: ASCII text
file1: ASCII text
file2: UTF-8 Unicode text
file3: Little-endian UTF-16 Unicode text
file4: ASCII text

Hi

I ran below command

Code:

tdc2solv112:kumarra# file -i ED_D_VLU______002_005_002_000_EN.oti
ED_D_VLU______002_005_002_000_EN.oti:   regular file

Didn't you say it's a .OTN file?

I said that we receive *.OTN extension file