Position() driving me nuts!

[David Jondreau]

In the process of trying to build a custom function, I've come across an issue I can't wrap my head around. I've blown nearly two hours to get to this point...

What would you expect this expression to return?

//Find the position of the 3rd 4.

Position( ¶ & "1¶2¶3¶4¶14¶4¶4" & ¶ ; ¶ & "4" & ¶ ; 1; 3)

Is it just me or is something screwy going on? This doesn't seem to be a problem with text, just numbers. I haven't tried other data types.

This is FMP10.0.3 Advanced on OSX 10.5.8.

[comment]

It's the same thing as here:

http://fmforums.com/forum/showtopic.php?tid/195744/

[David Jondreau]

Sonofa....I knew it was familiar! Shame I lack a memory.

I thought I had narrowed it down to an issue with the pilcrow dropping off if it was a number, but I hadn't tested very thoroughly.

So what's the answer to an inclusive PatternCount() function or Position() function?

I'm trying to build custom function that essentially combines my TypeSumField() with your CorrespondingValues().

I'm looking to grab a list of related line item amounts, grab a list of those same line item types, and create a new list that sums each line item type.

Similar to what BruceR does with repeating fields in the TypeSumField() discussion but without the need for extra fields.

Any tips would be welcome.

[Vaughan]

Is it just me or is something screwy going on?

I see the problem... that statement should have AND instead of OR.

Double the ¶s.

¶A¶¶B¶¶C...X¶

[comment]

I am not sure why you would need an inclusive function for this, but in any case - if you substitute ¶ with "¶¶", the rest should follow.