Skip site navigation (1) Skip section navigation (2)

Cleaning text with function?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Cleaning text with function?
Date: 2002-09-25 15:29:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Currently I have a perl script that I use to cleanse text fields in a file
for use in our mainframe.  I would like to do this as a function and bypass
using perl if possible.  Is this possible?  I do not have plperl installed
on the database due to server restrictions.
Example of current perl statement:

while (<>) {        # Streams the corrected text back to the original file

        s/¨/ /g;    # Character replace
         s/ª/ /g;    # Character replace
        s/`/ /g;    # Character replace
         s/¡/ /g;    # Character replace
        s/Ë/A/g;    # Character replace
        s/Ò/ /g;    # Character replace
        s/Ó/ /g;    # Character replace
        s/æ/E/g;    # Character replace
        s/ê/I/g;    # Character replace
        s/ì/I/g;    # Character replace
        s/ï/O/g;    # Character replace

        print;          # this goes to the temp filehandle, ARGVOUT,
               # not STDOUT as usual, so don't mess with it !


Patrick Hatcher
Legacy Integration Developer


pgsql-novice by date

Next:From: Tom LaneDate: 2002-09-25 15:29:51
Subject: Re: install problem
Previous:From: Phillip J. AllenDate: 2002-09-25 15:28:14
Subject: Re: Question about cygwin/Postgre

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group