RE: Splitting field

Dirk Is there any structure in the current field? Do the first n characters always contain the House number and never part of the Street, if so use select street[1,n], as house, street[n+1,to end] as new_street. If house number is at the beginning or end and delimited by a space you may be able to use TRIM. If there is no structure you will not be able to split automatically, each field will need to be examined. In the UK it might be possible to use some form of address validation software to do this external to the database (something like QAS), but I imagine you are not UK based ! Keith -> -----Original Message----- -> From: emmermacher@hotmail.com [mailto:emmermacher@hotmail.com] -> Sent: Friday, April 21, 2006 11:46 AM -> To: informix-list@iiug.org -> Subject: Splitting field -> -> -> 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 -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************