2009/10/13 John Wenmeekers <[email protected]>: > It is obvious that the substitute() takes the numbers 10, 11 and 12 as > separate digits. > > I'm looking for a logical explanation of this substitute behavior.
It's simply because the Substitute command performs its replacements in order, from first to last. Hence, any "1" is being substituted for "Jan": including the "1" that is part of "10" or part of "11". Try changing the order of substitutions so that the double-digit ones are done first. -- Tim Mansour <[email protected]> Neologica Print & Promotions ABN 63 904 335 408 Certified FileMaker 10 Developer "Reminds me of my safari in Africa. Somebody forgot the corkscrew and for several days we had to live on nothing but food and water." -- W.C. Fields
