text funnel brain freeze

[Bruce De Benedictis]

You could use the Arraytrim( function: Arraytrim(OriginalText,1,"]"). That
takes out the final "]" so you would probably want to use the Sandwich(
function to put it back in.

I note that the variables are given in two different orders in the
Programming Reference Wizard. This one is correct.

Bruce De Benedictis

> I need a text funnel that will leave all the text before the last ]
> character in a text string. Ie, will remove all the text after the
> last ] character in a text string.
> 
> I've got a field with text that looks like this:
> 
> [some text][some other text][text text text]text hanging off the end
> 
> or this
> 
> [some text][some other text]text hanging off the end
> 
> or even
> 
> [some text]
> 
> That last one has no text hanging off the end.
> 
> I'd like to delete the text hanging off the end if there is any,
> leaving me with the field containing:
> 
> [some text][some other text][text text text]
> [some text][some other text]
> [some text]
> 
> I feel certain that a text funnel would work. But I can't make it
> work. Can a text funnel do this?
> 
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna