Groups > comp.databases.filemaker > #3520

Re: formula question, nested positions

Path	csiph.com!news.mixmin.net!aioe.org!kHUH0E1elh1LaiXSGgExUQ.user.46.165.242.75.POSTED!not-for-mail
From	Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups	comp.databases.filemaker
Subject	Re: formula question, nested positions
Date	Fri, 3 Jun 2022 19:33:29 +1200
Organization	Aioe.org NNTP Server
Message-ID	<t7cdg9$18a8$1@gioia.aioe.org> (permalink)
References	<slrnt9eqvv.3rf.t-usenet@ID-685.user.individual.de> <t7c5sg$f9f$1@gioia.aioe.org> <slrnt9j91b.pgb.t-usenet@ID-685.user.individual.de>
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	8bit
Injection-Info	gioia.aioe.org; logging-data="41288"; posting-host="kHUH0E1elh1LaiXSGgExUQ.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent	Unison/2.2
X-Notice	Filtered by postfilter v. 0.9.2
Xref	csiph.com comp.databases.filemaker:3520

Show key headers only | 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