RE: Splitting field

Posted in 2006

Konikoff, Rob (Contractor) — Fri, 21 Apr 2006 09:17:06 -0400 — source: Usenet: comp.databases.informix

> -> 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