REPLACE function for 4GL

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Richie Smith — Tue, 5 Oct 1999 09:14:03 +0100 — source: Informix-list mailing list archive (1991-1998)

I'm trying to find a 4GL function that operates in the same way as REPLACE in 7.30 SQL. i.e. searches a given string for a substring and replaces it with something else. Any help, much appreciated

↪ replying to Richie Smith

Jonathan Leffler — Wed, 06 Oct 1999 00:26:20 -0700 — source: Informix-list mailing list archive (1991-1998)

Richie Smith wrote: > I'm trying to find a 4GL function that operates in the same way > as REPLACE in 7.30 SQL. i.e. searches a given string for a > substring and replaces it with something else. > > Any help, much appreciated There isn't one in standard I4GL 7.30. You can write your own, of course, in either C or I4GL. C will be faster but requires a C compiler and possibly custom runners. Try the IIUG software archive; it would be surprising if there wasn't something there. I have such code which can be added if necessary. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Glossary

4GL (Informix-4GL)