Location of a character in a string

Version: IDS 10 I looked at all string manipulation function that IDS provides but couldn't find: 1. Something that gives me the location of a character in a string. 2. Or, something that works like sed in terms of replacing characters using regular expression. If such functions are not available then I'll write my own.

On Tue, 2007-09-25 at 12:03 -0700, mohitanchlia@gmail.com wrote: > Version: IDS 10 > > I looked at all string manipulation function that IDS provides but > couldn't find: > > 1. Something that gives me the location of a character in a string. > 2. Or, something that works like sed in terms of replacing characters > using regular expression. I've never used it myself, but the regex datablade at http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_regexp.html might help. HTH, -- Carsten Haese http://informixdb.sourceforge.net