Hello outthere,

My question, is there an internal filemaker limitation on the numbers of nesting in a subsitute function? Example below. Is it wise to limit and to split up, or is there no known limit to the number of nestings?

Thanks

Harry

(example below)

--

Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( field to substitute,"?","Ä"), "?", "Å"), "

Hi Harry:

Amount of nested functions would probably be limited to the amount of characters allowed in a calculation, which I think is like 256. But, as you already know, you can combine calcs fields into one calc field to get around this

The 256 (253?) is for a continuous text string; the character limit is 30,000 characters. There's a limit of 170(?) or so possible tests in a CASE or nested IF function; I would assume that applies to nested Substitutes.

I don't guarantee the numbers (this is from an obscure clipping), but they sound close; I've seen the dialog messages; recently the 30,000, and often the 253 (forgetting to close a quote will get you that one). FileMaker will gracefully tell you when you get there.

Whoa! I was way off!