string append
monkeys paw asked whether a 4GL LET statement appending two CHAR(20) variables needs the source trimmed. Everett Mills and Mike Aubury answered that CLIPPED removes trailing blanks, for example LET source = source CLIPPED, addon, or with a " " between for a space. The poster confirmed and had simply forgotten CLIPPED. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I am appending two strings thusly, define source char(20), addon char(20) let source = source, addon Do i need to do a trim on the source string during the let statement?
If you want source "I am a string, " + addon "too" to look like this: "I am a string,too", use this: LET source = source CLIPPED, addon If you want "I am a string, too ", use this: LET source = source CLIPPED, " ", addon --EEM > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of monkeys paw > Sent: Wednesday, October 15, 2008 4:01 PM > To: informix-list@iiug.org > Subject: string append > > I am appending two strings thusly, > > define > source char(20), > addon char(20) > > let source = source, addon > > Do i need to do a trim on the source string during the let statement? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list
monkeys paw said: > I am appending two strings thusly, > > define > source char(20), > addon char(20) > > let source = source, addon > > Do i need to do a trim on the source string during the let statement? It depends. HTH. -- Bye now, Obnoxio http://obotheclown.blogspot.com/
Yes... In 4GL - the keyword you are looking for is probably 'CLIPPED'... On Wednesday 15 October 2008 22:01:10 monkeys paw wrote: > I am appending two strings thusly, > > define > source char(20), > addon char(20) > > let source = source, addon > > Do i need to do a trim on the source string during the let statement? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ
Thank you, i had forgotten the "clipped" function. > If you want source "I am a string, " + addon "too" to look like > this: "I am a string,too", use this: > > LET source = source CLIPPED, addon > > If you want "I am a string, too ", use this: > > LET source = source CLIPPED, " ", addon > > --EEM > >> -----Original Message----- >> From: informix-list-bounces@iiug.org [mailto:informix-list- >> bounces@iiug.org] On Behalf Of monkeys paw >> Sent: Wednesday, October 15, 2008 4:01 PM >> To: informix-list@iiug.org >> Subject: string append >> >> I am appending two strings thusly, >> >> define >> source char(20), >> addon char(20) >> >> let source = source, addon >> >> Do i need to do a trim on the source string during the let statement? >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list