RE: Splitting field

Assuming the house number is always the first 'word' in the field, and consists ONLY of the first word in the fields. What happens where the house number is actually a house name of more that one word "Dun Roamin'" !!?? Keith -> -----Original Message----- -> From: Konikoff, Rob (Contractor) [mailto:rob.konikoff@us.army.mil] -> Sent: Friday, April 21, 2006 2:17 PM -> To: Obnoxio The Clown; Simmons, Keith -> Cc: informix-list@iiug.org; emmermacher@hotmail.com -> Subject: RE: Splitting field -> -> -> > -> How can I do this with my old IDS 7.30? -> > -> A streetname can contains numbers and some house numbers have -> > -> characters... -> -> 1. Unload your KEY and your ADDRESS column -> 2. Split the column based on white space, probably using AWK -> outside the -> database, or an offline standalone package that supports space -> delimiters, depending on the size/amount of records -> 3. ALTER table to include your new columns, ST_NUM and ST_NAME -> 4. Reload your new columns based on the KEY and plug in the new data -> 5. ALTER table to drop your old column of combined ADDRESS data -> 6. Pray your data integrity guys don't kill you -> -> Rob -> ********************************************************************************** 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. **********************************************************************************