Re: unloading trailing spaces

"Dan, Rebecca, Cody Djuric" wrote: > > Informix gurus: > > I am trying to modify a text file by loading the file into an informix > database, performing updates in SQL through reference tables, and > unloading to an un-delimited text file. The problem I am running into > is that the trailing spaces (which I want included in the unload) are > only unloading 50% of the time. I am using a char[24] field type. Can > anyone please offer any suggestions on how to get the trailing spaces to > unload 100% of the time. > > Thanks > -Dan Hello Dan, if You are working on a UNIX-Machine the is an easy way. Use a char(25) field and put a character, You don't use in Your text on place 25 (e.g. "@"). Back on unix-shell You can do a "cat orgfile | tr -d @ > newfile", which will wipe off the "@". Wolfgang