RE: Splitting field

Posted in 2006

Dirk Emmermacher — Mon, 24 Apr 2006 09:37:46 +0000 — source: Usenet: comp.databases.informix

Hello Rob. Thanks for your answer (and all others too). I will test it. I hope the result will not be to cruel. I'm really, really happy about this change of structure... ... I have to modify a really large number of reports and forms too ;-). Best regards. Dirk > > > -> 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