Rick,
What Richard was trying to show, and what I do often, is to break the
middle function down into 3 pieces. One for the result text where the
middle function actually is, a number field to be the starting
position, and another number to be the length. Then you can fiddle
with the numbers (and the Position functions to generate them) without
breaking your calc and getting lost.
Do that just a few times and the middle function will never beat you
again.
Geoff
On Nov 18, 2009, at 3:19 PM, Richard S. Russell wrote:
On 2009 Nov 18, at 13:22, Rick O'Quinn wrote:
Geoff,
That worked perfect, and thanks for the additional tip on the Trim
wrap.... did the job. I may play around with Richard Russell's
solution too ...
Disclaimer: My "solution" was just a rough draft of an approach that
would have shortly yielded the result that Geoff gave you. I passed
it on more to show the thot process involved than to produce a
usable result, since Geoff had already done that.
