Remove pilcrow from RightValues

[HBMarlowe]

In Find mode I set my field to

"==" & RightValues (gTextField ; 1)

 

Because RightValues includes a pilcrow the search for exact match fails.

 

I've been using Filter to allow only alphanumeric characters, spaces, periods, ampersands, etc. That works fine.

 

Here's the question: Is there a more elegant way?

[David Head]

Of course there is a more elegant way! smiley-wink

 

Try this:

 

"==" & GetValue ( gTextField ; ValueCount ( gTextField ) )

 

But that will cost you a beer at Devcon smiley-tongue-out

[HBMarlowe]

But that will cost you a beer at Devcon smiley-tongue-out

 

I'm sure I owe you more than one by now, David. Many thanks.

 

I guess I should look at the list of functions from time to time, instead of just typing. Duh.Opps!

 

John