RE: Splitting field

Yea, but that's the easy way !! -> -----Original Message----- -> From: Obnoxio The Clown [mailto:obnoxio@serendipita.com] -> Sent: Friday, April 21, 2006 2:05 PM -> To: Simmons, Keith -> Cc: emmermacher@hotmail.com; informix-list@iiug.org -> Subject: RE: Splitting field -> -> -> -> Simmons, Keith said: -> > 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 ! -> -> Unload the table to a flat file and vi it. :o( -> -> > -> -----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. -> > -> ************************************************************* -> ********************* -> > -> > _______________________________________________ -> > Informix-list mailing list -> > Informix-list@iiug.org -> > http://www.iiug.org/mailman/listinfo/informix-list -> > -> -> -> -- -> Bye now, -> Obnoxio -> -> Information within this post contains forward looking -> statements within -> the meaning of Section 27A of the Securities Act of 1933 and -> Section 21B -> of the S E C Act of 1934. Statements that involve -> discussions with respect -> to projections of future events are not statements of -> historical fact and -> may be forward looking statements. Don't rely on them to -> make a decision. -> -> The poster is not a reporting company registered under the -> Exchange Act of -> 1934. -> -> I have received a life peerage from Her Majesty, who is not -> an officer, -> minister or affiliate Labour party member. -> -> I intend to recover my loan now, which could cause the parliamentary -> majority to go down, resulting in losses for you. Today's -> Labour party -> has: an accumulated deficit and a reliance on loans from officers and -> affiliates to pay expenses. It is not an operating political -> party. The -> party is going to need financing to continue as a going -> concern. A failure -> to finance could cause the party to go out of business. This -> report shall -> not be construed as any kind of investment advice or -> solicitation. You can -> lose all your money by investing in this party. ->

Can you supply a representative sample of the address data? Some idea of what we're dealing with would help. cheers