On Tue, Jul 1, 2008 at 12:44 PM, william humphrey <[EMAIL PROTECTED]> wrote: > Good evening and, as always, thanks for the help > > What's the best way to concatenate three fields to make one text string with > spaces between the words when you don't know how many or which of the three > fields will contain data and you don't want extra spaces in the result?
put empty into tConcat if field "One" is not empty then put field "One" & space after tConcat if field "Two" is not empty then put field "Two" & space after tConcat if field "Three" is not empty then put field "Three" & space after tConcat delete last char of tConcat Cheers, Sarah _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
