trim on unload or onpload

Posted in 2008

Topics: Data Types & Schema Design, Migration, Import/Export & Data Conversion

Floyd Wellershaus — Tue, 9 Dec 2008 19:14:01 -0600 (CST) — source: Usenet: comp.databases.informix

We are doing a data migration and have a need to trim trailing spaces out of some of our fields ( varchar and char ). Is there a way in hp loader to create a function to trim all fields during the unload ? Also is there a way to do it with unload ? Thanks, floyd

↪ replying to Floyd Wellershaus

Ian Goddard — Wed, 10 Dec 2008 10:54:51 +0000 — source: Usenet: comp.databases.informix

Floyd Wellershaus wrote: > We are doing a data migration and have a need to trim trailing spaces > out of some of our fields ( varchar and char ). > > Is there a way in hp loader to create a function to trim all fields > during the unload ? > Also is there a way to do it with unload ? > > Thanks, > floyd > man sed -- Ian Hotmail is for spammers. Real mail address is igoddard at nildram co uk