Hi I want to retreive from postgres database by removing the dos characters and the spaces from a perl file. It is like in the DB side there is " " and dos charcters in the table itself. So when I am doing a select query as it is checking in the table, the correct match is not obtained. I have TRIED after removing in the PERL side with substitution and all and confirmed this . Please give me some tips as what function I can use in the query to remove the space as well as DOS characters
thanks Anish