RE: Parse String in Stored Procedure

You need to define a "foreach" or "while" loop, stepping through the characters one at a time and lauding them across to another string value. If you need more detail let me know and I will see if I can get you an example of some of the work that I have done. On second thought let me see if I get something now. -- ***** -- -- Check Invalid Issuer FOREACH SELECT ii_inv_issuer INTO l_v_issuer FROM g_inv_issuer WHERE ii_inv_issuer[1,1] = Pi_ri_id[1,1] LET l_count = LENGTH(l_v_issuer) ; IF l_count = 8 THEN LET l_issuer = Pi_ri_id[1,8] ; ELIF l_count = 7 THEN LET l_issuer = Pi_ri_id[1,7] ; ELIF l_count = 6 THEN LET l_issuer = Pi_ri_id[1,6] ; ELIF l_count = 5 THEN LET l_issuer = Pi_ri_id[1,5] ; ELIF l_count = 4 THEN LET l_issuer = Pi_ri_id[1,4] ; ELIF l_count = 3 THEN LET l_issuer = Pi_ri_id[1,3] ; ELIF l_count = 2 THEN LET l_issuer = Pi_ri_id[1,2] ; ELIF l_count = 1 THEN LET l_issuer = Pi_ri_id[1,1] ; ELSE LET l_issuer = "" ; CONTINUE FOREACH ; END IF ; IF l_issuer = l_v_issuer THEN LET Po_err_code = 0 ; -- Set Inhouse Error Code RAISE EXCEPTION 13,0 ; -- Invalid / Illegal Issuer END IF END FOREACH ; * ***** -- David Reed david.reed@compuwin.co.za <mailto:david.reed@compuwin.co.za> -----Original Message----- From: Cook, Russell L [SMTP:Russell.Cook@marconi-is.com] Sent: Tuesday, August 31, 1999 11:28 PM To: 'informix-list@iiug.org' Subject: Parse String in Stored Procedure I need to create a stored procedure that parses an 8-character string, and determine if a dash (-) characters exist in this string. If a dash character exist in the string, I would like to delete it. Anyone have an experience do this or an example. Appreciate all of your help. Thanks in advance. Russ Russell L. Cook Marconi Integrated Systems, Inc (858) 592-5008 russell.cook@Marconi Integrated Systems, Inc