Hi,
I want to know how to replace Control-M character in a filed with space in informix. Any idea how to do it.


Bye.

if you are talking about a file then

:g/^V^M/s///g

actualy hit the keys control-V and Control-m, the control-V will be invisibale

Hi,
Its not in the file. I have control characters in some fileds of the database. When i read the column and if there is a contorl character in the filed, i should replace that control character with a space and write it to a file.


Bye.