| From: | tony <tony(at)animaproductions(dot)com> |
|---|---|
| To: | postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | getting rid of characters in database |
| Date: | 2002-03-27 10:40:19 |
| Message-ID: | 1017225619.12212.20.camel@vaio |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I have a problem with addresses in a database column that contain the
<return> character (possibly in Macintosh encoding...).
Is there an update query I can run on the column to "zap" the unwanted
character? I am not very good at regular expressions...
The fact that it is still in there is pretty strange because I had
cleaned everything up before importing the text file. Any ways you can
imagine all by yourselves the havoc it creates when exporting reports...
=:-D
Cheers
Tony
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PGMailList | 2002-03-27 12:37:44 | Re: command to Describe RULE |
| Previous Message | Dominique ROUSSEAU | 2002-03-27 08:45:07 | Re: INSERTs slow |