RE: Off-topic
- From: Bob Lofstrand <blofstrand@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Jul 2004 10:51:40 -0500
There is nothing (that I know of) in informix that is just like the
translate function. The closest would the replace function which is more
equivalent to the regexp substitute. (s/this/that) To get the same effect
you would need to nest the replace doing something crazy like
trim(replace(replace(replace(replace(replace(replace(replace(replace(replace
(replace(col1,'0',' '),'1',' '),'2',' '),'3',' '),'4',' '),'5',' '),'6','
'),'7',' '),'8',' '),'9',' ')). If you are going to be doing this on a
result set of any real size you should probably write a procedure to take
care of this.
Informix is a great engine but it has always lagged on the features.
-----Original Message-----
From: Santosh Varma [mailto:santosh.verma@xxxxxxx]
Sent: Thursday, July 15, 2004 5:20 AM
To: oracle-l@xxxxxxxxxxxxx
Cc: Jan.Korecki@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
oracle-l-bounce@xxxxxxxxxxxxx; rjamya@xxxxxxxxx
Subject: Off-topic
Hi Guys,
Sorry for this off-topic query..
I wanted to know the equivalent of translate command of oracle in informix.
i mean to say -> how to achieve the following ?
trim(translate(col1, '0123456789', ' ')) in informix/c ?
Santosh
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
