Removing spaces from the end of an attribute

Contains tips for configurators working with Aware IM
Post Reply
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Removing spaces from the end of an attribute

Post by tford »

Recent thread discussed removing spaces from the end of an attribute. Following is a formula that will accomplish it:

BO.Attribute=WORDS_FROM_LEFT(BO.Attribute,WORD_NUMBER(BO.Attribute))
Tom - V8.8 build 3137 - MySql / PostGres
ghilton
Posts: 196
Joined: Thu Sep 27, 2007 1:06 pm
Location: Manchester (UK)

Post by ghilton »

I have just rested the above and this works a treat. Thanks for sharing that with us Tom it has rid me of this issue!

Cool!
Post Reply