formula question, nested positions

Path	csiph.com!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From	Martin Τrautmann <t-usenet@gmx.net>
Newsgroups	comp.databases.filemaker
Subject	formula question, nested positions
Date	Wed, 1 Jun 2022 15:39:11 +0200
Organization	slrn user
Lines	48
Message-ID	<slrnt9eqvv.3rf.t-usenet@ID-685.user.individual.de> (permalink)
Reply-To	traut@gmx.de
Injection-Info	reader02.eternal-september.org; posting-host="4ab090caa834c48a61a85962a26d161a"; logging-data="11797"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/xg9YtHdhxTIe7PAFgZYbJ"
User-Agent	slrn/1.0.3 (Darwin)
Cancel-Lock	sha1:Gf/jNhBOigPzQTgdKqPY79wPz+Y=
X-No-Archive	Yes
Xref	csiph.com comp.databases.filemaker:3515

Show key headers only | View raw

Hi,

where is the bug in my formula?

I have a TEXT field where I want to enter a TIME,
but as an entry format which accepts

    12d3
as 12 days, 3 hours

(that's why I have to use it as a text field)

and time with the format 12:34 as
12 hours, 34 minutes
(instead of 12 minutes and 34 seconds)

So I created a case formula on field "t" which takes

PatternCount(t;":"); 
Time(
Left(t;Position(t;":";1;1)-1);
Left(Middle(t;Position(t;":";1;1)+1;99);
    Position(Middle(t;Position(t;":";1;1);99)&":"; ":";1;1)-1);
0)

That's a simplifed example which ignores seconds.

What's wrong with this formula?
  Middle(t;Position(t;":";1;1)+1;99) 
takes the content of e.g. 34 from 12:34,
or 34:56 from 12:34:56

I then want to find the position from this minutes-seconds substring up
to the next ":". For that reason I add another ":" to the position
string which makes sure that at least one ":" is found.

I must have got lost somewhere within these nested positions - but I do
not find where that happened.

I can use
 PatternCount(t;":"); 
 Let(
  [h= Left(t;Position(t;":";1;1)-1);
   ms= Middle(t;Position(t;":";1;1)+1;99);
   m=Left(ms;Position(ms&":";":";1;1)-1)];
  Time(h;m;0)
 );
as expected. But I wonder where my error was in the formula before.

Back to comp.databases.filemaker | Previous | Next — 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