Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #3520

Re: formula question, nested positions

Show all headers | View raw

On 2022-06-03 06:03:22 +0000, Martin Τrautmann said:
> On Fri, 3 Jun 2022 17:23:28 +1200, Helpful Harry wrote:
> 
>> b) The next Middle function is missing the +1, like in a),
>> to skip over the first : after the hours. Adding in that +1
>> means it is
>> Left(Middle(t;Position(t;":";1;1)+1;99);
>> Position(Middle(t;Position(t;":";1;1)#+1#;99)&":"; ":";1;1)-1)
>> Entering 12:34:56 then return 34 instead of empty text.
> 
> omg, yes - so it did not take the 34:56 part, but used :34:56 instead.
> Now I see why it always failed, since it found the initial : first

It's very very easy to miss something like that. That's why I tend to 
use separate Calculation fields for each step, which I can put on a 
"debug" layout to more easily see what is actually being calculated 
rather than what I think is being calculated.

One you know it's doing what it is supposed to be doing, you can always 
copy-paste the formulas over to a nested version if wanted (but making 
sure that version is working properly before deleting the separate 
ones).

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

formula question, nested positions Martin Τrautmann <t-usenet@gmx.net> - 2022-06-01 15:39 +0200
  Re: formula question, nested positions Helpful Harry <HelpfulHarry@BusyWorking.com> - 2022-06-02 10:44 +1200
    Re: formula question, nested positions Martin Τrautmann <t-usenet@gmx.net> - 2022-06-02 08:18 +0200
  Re: formula question, nested positions Helpful Harry <HelpfulHarry@BusyWorking.com> - 2022-06-03 17:23 +1200
    Re: formula question, nested positions Martin Τrautmann <t-usenet@gmx.net> - 2022-06-03 08:03 +0200
      Re: formula question, nested positions Helpful Harry <HelpfulHarry@BusyWorking.com> - 2022-06-03 19:33 +1200
        Re: formula question, nested positions Martin Τrautmann <t-usenet@gmx.net> - 2022-06-03 10:10 +0200
          Re: formula question, nested positions Helpful Harry <HelpfulHarry@BusyWorking.com> - 2022-06-04 10:00 +1200
            Re: formula question, nested positions Martin Τrautmann <t-usenet@gmx.net> - 2022-06-04 09:37 +0200

csiph-web