Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #3517

Re: formula question, nested positions

Show all headers | View raw

On Thu, 2 Jun 2022 10:44:14 +1200, Helpful Harry wrote:
> I don't really understand what data you're entering or what you're 
> wanting out of it, but it is VERY VERY easy to mess up complicated 
> nested functions by accidentally placing the ) or ; in the wrong place, 
> for example.

I want to enter data such as
t:
   3d23    -> 97:00
   12:34   -> 12:34
   48      -> 48:00

I want to add this data to another field

  timestamp = get(currentTimestamp)+t

Actually, I had to use get(currentTimestamp)+GetAsTime(t)

Yeah, nested functions can become VERY easy to mess them up.

But case functions are easy to debug, usually,

by changing

case(

patterncount(t,":"),
mytextfunction(t),
[...]
t)

to

case(

patterncount(t,":"),
mytextfunction(t)
&" x= " & step1
&" y= " & step2,

patterncount(t,":"),
mytextfunction(t),
[...]
t)

It's easy to add the same trigger before, for debugging purposes.

My problem is that my nested text functions do not show the proper ":"
position. They should indicate
  position("34" & ":",":",1,1) -1 = 2
for left("34",2) = 34
or 
position("34:56" & ":",":",1,1) -1 = 2
for left("34:56",2) = 34

Put the position function returns 0.

> Usually I create completely separate calculation fields to extract the 
> different pieces of data. They are much easier to debug since you can 
> see what each one is actually extracting.

But they make it much more complicated when you have to select fields
from dialogs, e.g. for sort, import or references,
even if I prefix each calculation field name with ©.

So I prefer to put much within a single calculation field and simplify
it by defining my own functions.

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