John, Are you certain Tom's CF works as you want? Try some of the example you originally gave. For example
TA123/TA-12-3 or 123TA45/12-3-TA-45 Tom's CF does not produce these results. [Sorry, Tom, I realize you said you didn't have to fully test your CF]. ====== I was going to submit a CF, but realized we didn't have a complete spec for the CF. For example, what should be the output if the input is "TA1234567"? Should it be "TA-12-34-56-7" or "TA-12-34-567"? You have given us the spec for 5 or fewer consecutive numbers [1 ; 12 ; 12-3 ; 12-34 ; 12-345 ], but what about 6 or more numbers? Should they be 12-34-56 12-34-56-7 or 12-34-567 12-34-56-78 12-34-56-78-9 or 12-34-56-789 etc With a complete spec, a CF can be produced (and fully tested). Regards, Jason L. DeLooze Annapolis, MD USA On 3/8/11 at 10:50 AM -0500, John Wenmeekers wrote: > Thanks to all of you. > > Tom, it works. > > I had nearly the same formula as you, only, I put it on the wrong line > inside the Case()....duh... > > Guess I was too long gazing at the screen....to see the obvious...while a > couple of other eyes can see the problem right away... > > Thanks again.... > > JW
