Does Informix-SQL have Perl-like functions?

Posted in 2003

Professor Bruno — Wed, 27 Aug 2003 22:58:59 +0000 (UTC) — source: Usenet: comp.databases.informix

Greetings, Apologies if this has been answered before. Does Informix-SQL have functions such as Perl's 'split'. We have a field which contains data delimited by "-" (dashes); the data is of variable length so we can't use field1[x,x] types of approaches. Any help in this regard would be appreciated. Thanks in advance. Max Pyziur pyz@brama.com

↪ replying to Professor Bruno

rkusenet — Wed, 27 Aug 2003 20:16:26 -0400 — source: Usenet: comp.databases.informix

"Professor Bruno" <pyz@panix.com> wrote in message news:bijd3j$mh8$1@reader2.panix.com... > Greetings, > > Apologies if this has been answered before. > > Does Informix-SQL have functions such as Perl's 'split'. > > We have a field which contains data delimited by "-" (dashes); the data > is of variable length so we can't use field1[x,x] types of > approaches. > > Any help in this regard would be appreciated. > > Thanks in advance. Informix does not have, but a function split can be written easily. to achieve the same, provided you are in 9.x version. You can call it as select split(fld1) from table where .... and it will spew back different fields. Please contact me at srkrishna at yahoo.com and I can help you there. rk- -- The email address is bogus.

↪ replying to Professor Bruno

Paul G. Brown — 28 Aug 2003 15:05:27 -0700 — source: Usenet: comp.databases.informix

Professor Bruno <pyz@panix.com> wrote in message news:<bijd3j$mh8$1@reader2.panix.com>... > Greetings, > > Apologies if this has been answered before. > > Does Informix-SQL have functions such as Perl's 'split'. http://www.iiug.org/software/index_ORDBMS.html And more specifically: http://www.iiug.org/software/archive/split_udr_README Which describes it.