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.