Re: Is there any way to get fields from column delimited by some delimeter

mohitanchlia@gmail.com wrote: > have a string for eg: "12|A|B", and need a function that takes "|" as > field delimeter and returns 2nd or say 3rd column. Is it possible to do > > this in informix. For Eg: If I ask for 2nd column I get "A". > > Also, is there a way to find a position of character in a string. For > Eg: "ABCD" - C's position is 3. > > --- > About how I am executing SQL: > I am not really a pro in informix, what I can tell is that I invoke > dbaccess and type SQL in there to execute it. I think it's informix > dynamic server (IDS) because I could use MULTISET which is part of IDS. > > Please let me know how do I find out if you need to know. I think > Informix version is 9 40 FC7 (if this makes sense). > -- > Write a parser function in 'C' and install it as a UDR. Art S. Kagel