Re: Splitting field

I would write a Stored procedure, you pass it one value and receive 3 back (Street, Number, Indicator) Let the SP do the split, and then if it is not 100% sure of the result, flag it. You can then manually check the ones where the SP was not 100%. First add the indicator column to the table, you can drop it, once you are done. Eg 1235 2de street could cause a problem but 1235 walker street can be identified You can then keep on expanding the rules in the SP until you are happy. Use the SP as part of the select to populate the new fields. Regards David Reed >>> "emmermacher@hotmail.com" <emmermacher@hotmail.com> 21/04/2006 10:46 p.m. >>> Hello list. In near future I will have a poor job. Its necessary to split a field into two fields (The field Street will split street and house_number. How can I do this with my old IDS 7.30? A streetname can contains numbers and some house numbers have characters... Thx in advance for your tips. Best regards. Dirk Emmermacher _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Transit New Zealand - A transport system that builds a better New Zealand. This electronic mail message together with any attachments is privileged. If you are not the intended recipient: - Do not copy, disclose or use the contents in any way. - Please let us know by return e-mail immediately, then destroy this message. Transit New Zealand is not responsible for any changes made to this message and/or any attachments after sending by Transit New Zealand. Thank you.