I would like to split a string inside stored procedure.
Lets say the String is 'Group1,gr2,testGr3'. I would like to split this string inside the stored procedure on the deliminator ,. and I would like to see the result as
Is it possible in Informix 9.X DB?
Please help me in this?
Thanks in advance.
This topic has been locked.
1 reply Latest Post - 2012-03-23T12:09:53Z by ClausSamuelsen
Pinned topic Split a string in stored procedure
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-03-23T12:09:53Z at 2012-03-23T12:09:53Z by ClausSamuelsen
ClausSamuelsen 120000N4RD11 PostsACCEPTED ANSWER
Re: Split a string in stored procedure2012-03-23T12:09:53Z in response to TestUser.You can download, compile and install the regexp bladelet. It contains the function regexp_split that does exactly what you are looking for.
See developerWorks article http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/db_regexp.html